Current location - Loan Platform Complete Network - Big data management - Big Data's-HIVE Getting Started (XXI)
Big Data's-HIVE Getting Started (XXI)
percentile( BIGINT col,p): p is a number between 0-1, such as 0.75 represents, take in the whole sample 75% percentile of the data value.

percentile( BIGINT col,array(p1,p2)): array(p1,p2) simultaneously take the entire sample of multiple percentile data values.

percentile_approx(col,p,B) :B is the precision, default 10000. where p can also be of type array, the same as the median function usage.