Support analytic NTILE function ------------------------------- Key: HIVE-952 URL: https://issues.apache.org/jira/browse/HIVE-952 Project: Hadoop Hive Issue Type: New Feature Components: Query Processor Reporter: Carl Steinbach
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: {code:sql} SELECT last_name, salary, NTILE(4) OVER (ORDER BY salary DESC) AS quartile FROM employees WHERE department_id = 100; {code} -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.