hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Omernik <j...@omernik.com>
Subject Count(distinct col) in Windowing
Date Thu, 15 May 2014 15:24:52 GMT
Is there a reason why I can't use

select col1, col2, count(distinct col3) over (PARTITION by col4 order by
col5 ROWS BETWEEN 5 PRECEDING AND FOLLOWING) as col1 from table

?

I am trying to see for any given window if there is a lot of variability in
a col4, and it just doesn't work with count distinct, count(1) works find,
but that's not the data I am looking for.

Mime
View raw message