Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement more optimization rules in risinglight #857

Open
caicancai opened this issue Nov 27, 2024 · 1 comment
Open

Implement more optimization rules in risinglight #857

caicancai opened this issue Nov 27, 2024 · 1 comment

Comments

@caicancai
Copy link
Contributor

caicancai commented Nov 27, 2024

I think I am ready. I have learned some operator implementation and SQL query optimization in Calcite and implemented in the arrow adapter in calcite. I will try it in Risinglight.

@wangrunji0408
Copy link
Member

wangrunji0408 commented Nov 27, 2024

I believe the existing rules are general enough to optimize queries in TPC-H, but they lack efficiency. Currently, we rely on the CBO engine to perform massive combination explorations to find the best plan, which is expensive. It's worth investing how to implement more RBOs within the egg framework, while keeping the rules as simple as they are now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants