BlogDocs

feat: Implement single inequality joins for join_where(#18727)

Merged
Comparing
adamreeve:iejoin_single
(
f45d106
) with
main
(
54218e7
)
-25%
IMPROVEMENTS
0
REGRESSIONS
1
UNTOUCHED
38
NEW
1
DROPPED
0
IGNORED
1

Benchmarks

Failed

test_groupby_h2oai_q3Regression
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q3
-25%
2.3 ms
3.1 ms

New

test_single_inequality
py-polars/tests/benchmark/test_join_where.py::test_single_inequality
N/A
N/A
80.8 ms

Passed

test_groupby_h2oai_q5
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q5
+24%
2.4 ms
1.9 ms
test_filter1
py-polars/tests/benchmark/test_filter.py::test_filter1
+11%
795.7 µs
717 µs
test_pdsh_q14
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q14
+11%
2.3 ms
2.1 ms
test_pdsh_q11
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q11
+9%
4.3 ms
3.9 ms
test_groupby_h2oai_q8
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q8
+8%
3.1 ms
2.9 ms
test_pdsh_q22
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q22
+5%
6.7 ms
6.3 ms
test_pdsh_q17
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q17
+5%
7 ms
6.7 ms
test_groupby_h2oai_q2
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q2
+4%
4.7 ms
4.5 ms
test_groupby_h2oai_q1
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q1
+4%
2.3 ms
2.2 ms
test_groupby_h2oai_q10
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q10
+4%
6.6 ms
6.4 ms
test_pdsh_q7
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q7
+3%
9.8 ms
9.5 ms
test_pdsh_q8
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q8
+3%
5.5 ms
5.3 ms
test_write_read_scan_large_csv
py-polars/tests/benchmark/test_io.py::test_write_read_scan_large_csv
+3%
31.5 ms
30.6 ms
test_pdsh_q19
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q19
+3%
7.6 ms
7.4 ms
test_pdsh_q18
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q18
+2%
11.9 ms
11.7 ms
test_pdsh_q10
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q10
+2%
6.3 ms
6.2 ms
test_pdsh_q9
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q9
+1%
25.8 ms
25.4 ms
test_pdsh_q15
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q15
+1%
2.5 ms
2.4 ms
test_groupby_h2oai_q4
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q4
+1%
1.9 ms
1.9 ms
test_pdsh_q3
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q3
+1%
5.8 ms
5.8 ms
test_non_strict_inequalities
py-polars/tests/benchmark/test_join_where.py::test_non_strict_inequalities
+1%
175.3 ms
173.9 ms
test_groupby_h2oai_q6
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q6
+1%
12.5 ms
12.4 ms
test_to_numpy_series_zero_copy
py-polars/tests/benchmark/interop/test_numpy.py::test_to_numpy_series_zero_copy
0%
124.4 µs
124.1 µs
test_strict_inequalities
py-polars/tests/benchmark/test_join_where.py::test_strict_inequalities
0%
169.1 ms
168.8 ms
test_pdsh_q1
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q1
0%
16.5 ms
16.5 ms
test_to_numpy_series_with_nulls
py-polars/tests/benchmark/interop/test_numpy.py::test_to_numpy_series_with_nulls
0%
435.9 µs
435.4 µs
test_to_numpy_series_chunked
py-polars/tests/benchmark/interop/test_numpy.py::test_to_numpy_series_chunked
0%
271.2 µs
270.9 µs
test_pdsh_q21
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q21
0%
211.8 ms
211.8 ms
test_pdsh_q5
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q5
0%
5.1 ms
5.1 ms
test_groupby_h2oai_q9
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q9
0%
26.1 ms
26.2 ms
test_pdsh_q6
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q6
-1%
1.9 ms
1.9 ms
test_pdsh_q16
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q16
-1%
7.5 ms
7.6 ms
test_pdsh_q20
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q20
-2%
6.2 ms
6.3 ms
test_pdsh_q13
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q13
-2%
9.6 ms
9.7 ms
test_pdsh_q12
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q12
-4%
5.9 ms
6.1 ms
test_pdsh_q2
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q2
-5%
3.8 ms
3.9 ms
test_pdsh_q4
py-polars/tests/benchmark/test_pdsh.py::test_pdsh_q4
-7%
4.8 ms
5.1 ms
test_groupby_h2oai_q7
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q7
-15%
2 ms
2.4 ms

Ignored

test_filter2Ignored
py-polars/tests/benchmark/test_filter.py::test_filter2
-1%
1.1 ms
1.1 ms

Commits

Click on a commit to change the comparison range
base
main
54218e7
-25%
Add test for single inequality with slice
f45d106
2 months ago
by adamreeve
ResourcesHomePricingDocsBlogGitHubChangelog
Copyright © 2024 CodSpeed Technology SAS. All rights reserved.