[HIVE-22292] Implement Hypothetical-Set Aggregate Functions

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: UDF
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 04/Oct/19 06:54
• Updated: 27/Feb/24 22:23
• Resolved: 06/Nov/19 04:13

Description

<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

Example:

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);

SELECT rank(6) WITHIN GROUP (ORDER BY column1) FROM table1;

2

Issue Links

• links to: Review Board