feat(optimizer): add common subplan elimination optimization rule
#6788Comparing
Lucas61000:issue-2423
(6301851
) withmain
(b9e744a
)-1%
- Untouched
- 40
- Ignored
- 4
- Skipped
- 10
No successful run was found on main ( 9c99919) during the generation of this report, so b9e744a was used instead as the comparison base. There might be some changes unrelated to this pull request in this report.
Benchmarks
54 total
test_clickbench_sql[4]
tests/benchmarks/test_clickbench.py+7%
81.1 ms75.8 ms
test_tpch_sql[1-in-memory-10]
tests/benchmarks/test_local_tpch.py+4%
177 ms170.4 ms
test_clickbench_sql[42]
tests/benchmarks/test_clickbench.py+2%
84.2 ms82.5 ms
test_tpch_sql[1-in-memory-1]
tests/benchmarks/test_local_tpch.py+1%
423.9 ms419.4 ms
test_explain[100 Small Files]
tests/benchmarks/test_interactive_reads.py+1%
10.2 ms10.2 ms
test_show[1 Small File]
tests/benchmarks/test_interactive_reads.py0%
12.2 ms12.2 ms
test_clickbench_sql[41]
tests/benchmarks/test_clickbench.py0%
65.2 ms65 ms
test_tpch_sql[1-in-memory-9]
tests/benchmarks/test_local_tpch.py0%
250 ms249.8 ms
test_tpch_sql[1-in-memory-3]
tests/benchmarks/test_local_tpch.py0%
120.6 ms120.5 ms
test_iter_rows_first_row[1 Small File]
tests/benchmarks/test_interactive_reads.py0%
34.1 ms34.1 ms
test_read_jsonl_with_limit
tests/benchmarks/test_json_reads.py0%
68.1 ms68.1 ms
test_clickbench_sql[37]
tests/benchmarks/test_clickbench.py0%
183.8 ms184 ms
test_read_jsonl_nested_list
tests/benchmarks/test_json_reads.py0%
454.8 ms455.4 ms
test_tpch_sql[1-in-memory-5]
tests/benchmarks/test_local_tpch.py0%
113.5 ms113.7 ms
test_clickbench_sql[36]
tests/benchmarks/test_clickbench.py0%
485.3 ms486.7 ms
test_tpch_sql[1-in-memory-4]
tests/benchmarks/test_local_tpch.py0%
85.5 ms85.8 ms
test_read_jsonl_with_explicit_schema
tests/benchmarks/test_json_reads.py0%
1.7 s1.7 s
test_read_jsonl_with_column_projection
tests/benchmarks/test_json_reads.py0%
1.3 s1.3 s
test_read_jsonl_wide_table
tests/benchmarks/test_json_reads.py0%
1.7 s1.7 s
test_tpch_sql[1-in-memory-6]
tests/benchmarks/test_local_tpch.py0%
33 ms33.2 ms
test_read_jsonl_string
tests/benchmarks/test_json_reads.py-1%
329.7 ms331.6 ms
test_count[100 Small Files]
tests/benchmarks/test_interactive_reads.py-1%
50.2 ms50.5 ms
test_read_jsonl_nested_struct
tests/benchmarks/test_json_reads.py-1%
499.7 ms503.1 ms
test_clickbench_sql[7]
tests/benchmarks/test_clickbench.py-1%
18.1 ms18.2 ms
test_read_jsonl_boolean
tests/benchmarks/test_json_reads.py-1%
357 ms359.8 ms
Commits
Click on a commit to change the comparison rangeBase
main
b9e744a
-0.96%
fix: handle mixed-equality hash buckets in common subplan elimination
6301851
13 hours ago
by Lucas61000