Avatar for the pola-rs user
pola-rs
polars
BlogDocsChangelog

feat: Add SQL support for `INTERSECT` and `EXCEPT` ops

#16960Merged
Comparing
alexander-beedie:sql-except-intersect
(
e21097f
) with
main
(
687dee3
)
CodSpeed Performance Gauge
+2%
Improvements
0
Regressions
0
Untouched
37
New
0
Dropped
0
Ignored
1

Benchmarks

Passed

test_tpch_q14
py-polars/tests/benchmark/test_tpch.py::test_tpch_q14
CodSpeed Performance Gauge
+15%
2.5 ms
2.2 ms
test_groupby_h2oai_q5
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q5
CodSpeed Performance Gauge
+13%
2.1 ms
1.8 ms
test_filter1
py-polars/tests/benchmark/test_filter.py::test_filter1
CodSpeed Performance Gauge
+10%
803.5 µs
727.5 µs
test_tpch_q4
py-polars/tests/benchmark/test_tpch.py::test_tpch_q4
CodSpeed Performance Gauge
+10%
5.1 ms
4.6 ms
test_tpch_q3
py-polars/tests/benchmark/test_tpch.py::test_tpch_q3
CodSpeed Performance Gauge
+10%
6.3 ms
5.8 ms
test_tpch_q7
py-polars/tests/benchmark/test_tpch.py::test_tpch_q7
CodSpeed Performance Gauge
+8%
10.1 ms
9.3 ms
test_tpch_q5
py-polars/tests/benchmark/test_tpch.py::test_tpch_q5
CodSpeed Performance Gauge
+8%
5.5 ms
5.1 ms
test_tpch_q22
py-polars/tests/benchmark/test_tpch.py::test_tpch_q22
CodSpeed Performance Gauge
+8%
6.7 ms
6.2 ms
test_tpch_q10
py-polars/tests/benchmark/test_tpch.py::test_tpch_q10
CodSpeed Performance Gauge
+7%
6.7 ms
6.3 ms
test_tpch_q19
py-polars/tests/benchmark/test_tpch.py::test_tpch_q19
CodSpeed Performance Gauge
+5%
8 ms
7.6 ms
test_tpch_q15
py-polars/tests/benchmark/test_tpch.py::test_tpch_q15
CodSpeed Performance Gauge
+5%
2.5 ms
2.3 ms
test_tpch_q2
py-polars/tests/benchmark/test_tpch.py::test_tpch_q2
CodSpeed Performance Gauge
+5%
4.9 ms
4.7 ms
test_groupby_h2oai_q10
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q10
CodSpeed Performance Gauge
+4%
6.5 ms
6.2 ms
test_tpch_q11
py-polars/tests/benchmark/test_tpch.py::test_tpch_q11
CodSpeed Performance Gauge
+3%
4.2 ms
4.1 ms
test_tpch_q17
py-polars/tests/benchmark/test_tpch.py::test_tpch_q17
CodSpeed Performance Gauge
+3%
6.9 ms
6.7 ms
test_tpch_q1
py-polars/tests/benchmark/test_tpch.py::test_tpch_q1
CodSpeed Performance Gauge
+2%
16.9 ms
16.5 ms
test_groupby_h2oai_q7
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q7
CodSpeed Performance Gauge
+2%
2.1 ms
2.1 ms
test_write_read_scan_large_csv
py-polars/tests/benchmark/test_io.py::test_write_read_scan_large_csv
CodSpeed Performance Gauge
+2%
33.4 ms
32.8 ms
test_groupby_h2oai_q6
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q6
CodSpeed Performance Gauge
+1%
12.5 ms
12.4 ms
test_tpch_q12
py-polars/tests/benchmark/test_tpch.py::test_tpch_q12
CodSpeed Performance Gauge
+1%
6.5 ms
6.4 ms
test_tpch_q6
py-polars/tests/benchmark/test_tpch.py::test_tpch_q6
CodSpeed Performance Gauge
+1%
1.9 ms
1.9 ms
test_to_numpy_series_zero_copy
py-polars/tests/benchmark/interop/test_numpy.py::test_to_numpy_series_zero_copy
CodSpeed Performance Gauge
0%
128.3 µs
128 µs
test_to_numpy_series_chunked
py-polars/tests/benchmark/interop/test_numpy.py::test_to_numpy_series_chunked
CodSpeed Performance Gauge
0%
276.7 µs
276.2 µs
test_to_numpy_series_with_nulls
py-polars/tests/benchmark/interop/test_numpy.py::test_to_numpy_series_with_nulls
CodSpeed Performance Gauge
0%
311.6 µs
311.4 µs
test_tpch_q21
py-polars/tests/benchmark/test_tpch.py::test_tpch_q21
CodSpeed Performance Gauge
-1%
206 ms
208.4 ms
test_tpch_q20
py-polars/tests/benchmark/test_tpch.py::test_tpch_q20
CodSpeed Performance Gauge
-1%
6.4 ms
6.5 ms
test_groupby_h2oai_q9
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q9
CodSpeed Performance Gauge
-1%
24.7 ms
25 ms
test_tpch_q9
py-polars/tests/benchmark/test_tpch.py::test_tpch_q9
CodSpeed Performance Gauge
-1%
25.4 ms
25.8 ms
test_groupby_h2oai_q3
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q3
CodSpeed Performance Gauge
-2%
2.4 ms
2.4 ms
test_tpch_q8
py-polars/tests/benchmark/test_tpch.py::test_tpch_q8
CodSpeed Performance Gauge
-2%
6.2 ms
6.3 ms
test_groupby_h2oai_q2
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q2
CodSpeed Performance Gauge
-2%
4.5 ms
4.6 ms
test_tpch_q16
py-polars/tests/benchmark/test_tpch.py::test_tpch_q16
CodSpeed Performance Gauge
-2%
7.3 ms
7.5 ms
test_groupby_h2oai_q8
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q8
CodSpeed Performance Gauge
-2%
2.8 ms
2.9 ms
test_groupby_h2oai_q4
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q4
CodSpeed Performance Gauge
-2%
1.9 ms
1.9 ms
test_tpch_q18
py-polars/tests/benchmark/test_tpch.py::test_tpch_q18
CodSpeed Performance Gauge
-2%
11.4 ms
11.7 ms
test_tpch_q13
py-polars/tests/benchmark/test_tpch.py::test_tpch_q13
CodSpeed Performance Gauge
-4%
9.8 ms
10.2 ms
test_groupby_h2oai_q1
py-polars/tests/benchmark/test_group_by.py::test_groupby_h2oai_q1
CodSpeed Performance Gauge
-10%
2.2 ms
2.4 ms

Ignored

test_filter2Ignored
py-polars/tests/benchmark/test_filter.py::test_filter2
CodSpeed Performance Gauge
-4%
1 ms
1.1 ms

Commits

Click on a commit to change the comparison range
Base
main
687dee3
+2%
feat: Add SQL support for `INTERSECT` and `EXCEPT` ops
e21097f
7 months ago
by alexander-beedie
Home Terms PrivacyDocs