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)
