News for hackers. Stuff that matters.
Re:The SQL filter clause: selective aggregates by rubyfan on Monday May 30, 2016 @03:41PM (#11802746)
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/LanguageMan...

There are no comments on this comment yet.