Is this all that different from Hive's analytic functions? I don't think I can put a WHERE filter right in the OVER clause though. SELECT a, COUNT(b) OVER (PAR

Is this all that different from Hive's analytic functions? I don't think I can put a WHERE filter right in the OVER clause though. SELECT a, COUNT(b) OVER (PARTITION BY c) FROM T; https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnalytics https://cwiki.apache.org/confluence/display/Hive/LanguageMan...