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

aggregate function with some options is not supported ? #87

Open
yjhjstz opened this issue May 25, 2024 · 1 comment
Open

aggregate function with some options is not supported ? #87

yjhjstz opened this issue May 25, 2024 · 1 comment
Labels
question Further information is requested

Comments

@yjhjstz
Copy link

yjhjstz commented May 25, 2024 •
edited
Loading 

-- aggregate function with some options is not supported
SELECT create_immv('mv_ivm18', 'SELECT COUNT(DISTINCT i)  FROM mv_base_a');

I want to know why COUNT(DISTINCT i) not supported ?
@yugo-n yugo-n added the question Further information is requested label Oct 14, 2024
@yugo-n
Copy link
Collaborator

yugo-n commented Oct 14, 2024

I want to know why COUNT(DISTINCT i) not supported ?

This support is not implemented because it needs more complex logic than the current implementation handling simple count(i). For example, to support incremental maintenance for views including count(distinct i), it is required to maintain all distinct values stored in the column in addition to the actual count results.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
question Further information is requested
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@yugo-n @yjhjstz