Details
-
New Feature
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
NTILE analytic function RANK DENSE_RANK
Description
The NTILE function divides a set of ordered rows into equally sized buckets and assigns a bucket number to each row.
Useful for calculating tertiles, quartiles, quintiles, etc.
Example:
SELECT last_name, salary, NTILE(4) OVER (ORDER BY salary DESC) AS quartile FROM employees WHERE department_id = 100;
Attachments
Issue Links
- is superceded by
-
HIVE-896 Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.
- Closed