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.

Sign up for GitHub

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

Jump to bottom

Fixed size of HashTable when Limit is used #9900

Open
guo-shaoge opened this issue Feb 23, 2025 · 0 comments
Open

Fixed size of HashTable when Limit is used #9900

guo-shaoge opened this issue Feb 23, 2025 · 0 comments
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@guo-shaoge
Copy link
Contributor

Enhancement

For table t1, assume the NDV of c1 of t1 is 100000.
For quey like: select max(c1) from t1 group by c2 limit 100;
The HashTable of Aggregtion should be fixed 100 instead of 100000 because we onley need 100 rows
@guo-shaoge guo-shaoge added the type/enhancement The issue or PR belongs to an enhancement. label Feb 23, 2025
@guo-shaoge guo-shaoge mentioned this issue Dec 4, 2024
Open
@guo-shaoge guo-shaoge changed the title fixed size of HashTable when Limit is used Fixed size of HashTable when Limit is used Feb 24, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@guo-shaoge