1.1 - 8.10 - Percentiles (ML Engine) - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
October 2019
Content Type
Programming Reference
Publication ID
English (United States)

The Percentiles function creates percentiles for groups of numbers. The nth percentile is the smallest value in a data set that is greater than n% of the values.

Use this function when the number of input data partitions is large and you want to find the percentile for each group. Each group must fit on a single worker node. The maximum number of input rows in each group that the function can process depends on the cluster configuration. To find percentile statistics for a very large input group that requires multiple workers, use the function Approximate Percentile (ML Engine).