The NTILE function divides the ordered partition into a specified number of bucket groups and assigns a bucket number to each row in the partition.
Tag: NTILE function in Apache Hive
Best Usage of NTILE function in SQL Server and other RDBMSs
SQL Server NTILE() is a window function that distributes rows of an ordered partition right into a unique quantity of approximately same partition or group
Big Data & SQL 