Options

Count distinct over a window resulting in error 4249 when using Vertica v7.1.1-2

Notice that count distinct without a window clause works fine but throws an error when a window is included.
rna=> select version();              version
------------------------------------
 Vertica Analytic Database v7.1.1-2
(1 row)
rna=> select count(version) from (select version()) x;
 count
-------
     1
(1 row)
rna=> select count(distinct version) from (select version()) x;
 count
-------
     1
(1 row)
rna=> select x, count(version)over(partition by x) from (select 1 x, version()) x;
 x | ?column?
---+----------
 1 |        1
(1 row)
rna=> select x, count(distinct version)over(partition by x) from (select 1 x, version()) x;

Leave a Comment

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