You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Krisztian Kasa (Jira)" <ji...@apache.org> on 2019/10/04 06:55:00 UTC
[jira] [Created] (HIVE-22292) Implement Hypothetical-Set Aggregate
Functions
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)