The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

count(distinct ) over() is supported?

KaitoKaito Employee
edited December 2018 in General Discussion

I get the following error when I use "count(distinct ) over()". If you have a workaroud, could you share it with me?

==Error message==
 [Vertica][VJDBC](7830) ERROR: Only MIN/MAX and AND/OR are allowed to use DISTINCT


Thanks in advance,____> > > > > ``>


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.