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

syntax sugar : compact table #3176

Closed
Tracked by #1780
dantengsky opened this issue Nov 30, 2021 · 0 comments · Fixed by #3182
Closed
Tracked by #1780

syntax sugar : compact table #3176

dantengsky opened this issue Nov 30, 2021 · 0 comments · Fixed by #3182
Labels
A-query Area: databend query C-improvement Category: improvement

Comments

@dantengsky
Copy link
Member

dantengsky commented Nov 30, 2021

Summary

Data inserted continuously as of some chunks, will 1) harm the scan performance 2) not storage efficient.

As PR

merged, a simple compact could be done by rewriting compact table T into insert overwrite T select * from T.

query/src/sql/statements/statement_show_tables.rs might be a good reference

let's take 1) partition/clustering 2) already compacted/optimized segments into account in next steps

@dantengsky dantengsky changed the title compact table by rewrite compact table T to insert overwrite table select * from T compact table Nov 30, 2021
@dantengsky dantengsky added A-query Area: databend query C-improvement Category: improvement labels Nov 30, 2021
@dantengsky dantengsky changed the title compact table syntax sugar : compact table Dec 1, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-query Area: databend query C-improvement Category: improvement
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant