Krisztian Kasa created HIVE-22292: ------------------------------------- Summary: Implement Hypothetical-Set Aggregate Functions Key: HIVE-22292 URL: https://issues.apache.org/jira/browse/HIVE-22292 Project: Hive Issue Type: Improvement Components: UDF Reporter: Krisztian Kasa Assignee: Krisztian Kasa Fix For: 4.0.0
{code} <hypothetical set function> ::= <rank function type> <left paren> <hypothetical set function value expression list> <right paren> <within group specification> <rank function type> ::= RANK | DENSE_RANK | PERCENT_RANK | CUME_DIST {code} Example: {code} CREATE TABLE table1 (column1 int); INSERT INTO table1 VALUES (NULL), (3), (8), (13), (7), (6), (20), (NULL), (NULL), (10), (7), (15), (16), (8), (7), (8), (NULL); {code} {code} SELECT rank(6) WITHIN GROUP (ORDER BY column1) FROM table1; {code} {code} 2 {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)