Skip to content
This repository was archived by the owner on May 7, 2026. It is now read-only.

chore: update tpch code#1389

Merged
Genesis929 merged 7 commits into
mainfrom
tpch_updates_huanc
Feb 13, 2025
Merged

chore: update tpch code#1389
Genesis929 merged 7 commits into
mainfrom
tpch_updates_huanc

Conversation

@Genesis929
Copy link
Copy Markdown
Collaborator

@Genesis929 Genesis929 commented Feb 12, 2025

Thank you for opening a Pull Request! Before submitting your PR, there are a few things you can do to make sure it goes smoothly:

  • Make sure to open an issue as a bug/issue before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea
  • Ensure the tests and linter pass
  • Code coverage does not decrease (if any source code was changed)
  • Appropriate docs were updated (if necessary)

Metrics based on 12 runs for 1t unordered:

Local Execution Time (min)

Benchmark_Name Baseline Updated
tpch/q14.py_1t_unordered 7.976918 7.747843
tpch/q17.py_1t_unordered 24.014622 10.093254
tpch/q20.py_1t_unordered 18.520704 17.751336
tpch/q22.py_1t_unordered 12.037383 10.353648
tpch/q3.py_1t_unordered 22.322292 18.405881
tpch/q5.py_1t_unordered 23.868598 16.491437

BigQuery Execution Time (min)

Benchmark_Name Baseline Updated
tpch/q14.py_1t_unordered 5.592 5.233
tpch/q17.py_1t_unordered 21.660 7.565
tpch/q20.py_1t_unordered 14.005 13.517
tpch/q22.py_1t_unordered 9.838 8.086
tpch/q3.py_1t_unordered 19.275 15.161
tpch/q5.py_1t_unordered 19.096 11.758

Local Execution Time (median)

Benchmark_Name Baseline Updated
tpch/q14.py_1t_unordered 8.662320 8.373590
tpch/q17.py_1t_unordered 31.300356 12.381444
tpch/q20.py_1t_unordered 20.960554 19.076680
tpch/q22.py_1t_unordered 17.360701 15.784335
tpch/q3.py_1t_unordered 25.989541 25.777564
tpch/q5.py_1t_unordered 26.776416 20.243388

BigQuery Execution Time (median)

Benchmark_Name Baseline Updated
tpch/q14.py_1t_unordered 6.1195 5.6080
tpch/q17.py_1t_unordered 28.5360 9.9045
tpch/q20.py_1t_unordered 16.6310 14.7815
tpch/q22.py_1t_unordered 14.9880 13.3400
tpch/q3.py_1t_unordered 22.9590 22.7710
tpch/q5.py_1t_unordered 21.4855 15.1245

@product-auto-label product-auto-label Bot added size: m Pull request size is medium. api: bigquery Issues related to the googleapis/python-bigquery-dataframes API. labels Feb 12, 2025
@Genesis929 Genesis929 marked this pull request as ready for review February 13, 2025 22:36
@Genesis929 Genesis929 requested review from a team February 13, 2025 22:36
@Genesis929 Genesis929 added the owlbot:run Add this label to trigger the Owlbot post processor. label Feb 13, 2025
@gcf-owl-bot gcf-owl-bot Bot removed the owlbot:run Add this label to trigger the Owlbot post processor. label Feb 13, 2025
@Genesis929 Genesis929 merged commit 534f7b4 into main Feb 13, 2025
@Genesis929 Genesis929 deleted the tpch_updates_huanc branch February 13, 2025 23:14
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.

Labels

api: bigquery Issues related to the googleapis/python-bigquery-dataframes API. size: m Pull request size is medium.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants