percentiletdigestmv - Apache Pinot Docs

Apache Pinot Docs

Search…

latest

Basics

Getting Started

For Users

External Clients

For Developers

Design Documents

For Operators

Deployment and Monitoring

Command-Line Interface (CLI)

Configuration Recommendation Engine

Configuration Reference

Ingestion Job Spec

DISTINCTCOUNTBITMAP

DISTINCTCOUNTBITMAPMV

DISTINCTCOUNTHLL

DISTINCTCOUNTHLLMV

DISTINCTCOUNTMV

DISTINCTCOUNTRAWHLL

DISTINCTCOUNTRAWHLLMV

DISTINCTCOUNTRAWTHETASKETCH

DISTINCTCOUNTTHETASKETCH

DATETIMECONVERT

FromEpochBucket

JSONPATHARRAYDEFAULTEMPTY

jsonextractscalar

percentileestmv

percentiletdigest

percentiletdigestmv

SEGMENTPARTITIONEDDISTINCTCOUNT

ST_GeogFromText

ST_GeometryType

ST_GeomFromText

toSphericalGeography

RESOURCES

Integrations

Powered By GitBook

percentiletdigestmv

This section contains reference documentation for the PERCENTILETDIGESTMV function.

Returns the Nth percentile of the group using T-digest algorithm.
Signature
PERCENTILETDIGESTMV(colName, N)
Usage Examples
These examples are based on the Hybrid Quick Start.
1
select PERCENTILETDIGESTMV(DivLongestGTimes, 50) AS value
2
from airlineStats 
3
where arraylength(DivLongestGTimes) > 1
Copied!
value
10
1
select PERCENTILETDIGESTMV(DivLongestGTimes, 90) AS value
2
from airlineStats 
3
where arraylength(DivLongestGTimes) > 1
Copied!
value
44
1
select PERCENTILETDIGESTMV(DivLongestGTimes, 99.9) AS value
2
from airlineStats 
3
where arraylength(DivLongestGTimes) > 1
Copied!
value
108

percentiletdigest

Last modified 18d ago

Copy link

Contents