In-Database Approximate Median and Percentile Functions

Moderator: NorbertKrupa

Post Reply
User avatar
Site Admin
Site Admin
Posts: 1824
Joined: Sat Jan 21, 2012 4:58 am

In-Database Approximate Median and Percentile Functions

Post by JimKnicely » Thu Jun 15, 2017 2:16 pm

New Vertica blog post authored by Ginger Ni!

Median and percentile functions are commonly used data statistic functions. They are also used in other sophisticated data analysis algorithms, such as the robust z-Score normalization function. Vertica has exact MEDIAN and PERCENTILE_CONT functions, but these functions do not scale well for extremely large data sets, because the functions must sort the entire data set to calculate exact values. Sometimes, approximations of the median and percentile are adequate. Vertica 8.1.0 introduced support for two approximate functions: APPROXIMATE_MEDIAN and APPROXIMATE_PERCENTILE

Read more here: ... functions/
Jim Knicely


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”