[ https://issues.apache.org/jira/browse/HIVE-952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lars Francke resolved HIVE-952. ------------------------------- Resolution: Fixed This has been fixed in the meantime. > Support analytic NTILE function > ------------------------------- > > Key: HIVE-952 > URL: https://issues.apache.org/jira/browse/HIVE-952 > Project: Hive > Issue Type: New Feature > Components: OLAP, Query Processor, UDF > 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 was sent by Atlassian JIRA (v6.3.4#6332)