We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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