THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!

Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Comment: count(distinct ...) over () does not seem to be supported https://issues.apache.org/jira/browse/HIVE-10141

...

Code Block

	sql
	sql

SELECT a, LAG(a, 3, 0) OVER (PARTITION BY b ORDER BY C)
FROM T;

Distinct counting for each partition

...

SELECT a, COUNT(distinct a) OVER (PARTITION BY b)
FROM T;