Functions

This page contains reference documentation for functions in Apache Pinot.

This page contains reference documentation for functions in Apache Pinot.

ABS ADD arrayConcatDouble arrayConcatFloat arrayConcatInt arrayConcatLong arrayConcatString arrayContainsInt arrayContainsString arrayDistinctInt arrayDistinctString arrayIndexOfInt arrayIndexOfString ARRAYLENGTH arrayRemoveInt arrayRemoveString arrayReverseInt arrayReverseString arraySliceInt arraySliceString arraySortInt arraySortString arrayUnionInt arrayUnionString AVGMV Base64 caseWhen ceil CHR codepoint concat count COUNTMV DATETIMECONVERT DATETRUNC day dayOfWeek dayOfYear DISTINCT DISTINCTCOUNT DISTINCTCOUNTBITMAP DISTINCTCOUNTHLLMV DISTINCTCOUNTHLL DISTINCTCOUNTBITMAPMV DISTINCTCOUNTMV DISTINCTCOUNTRAWHLL DISTINCTCOUNTRAWHLLMV DISTINCTCOUNTRAWTHETASKETCH DISTINCTCOUNTTHETASKETCH DIV exp Extract FromDateTime FLOOR FromEpoch FromEpochBucket Histogram hour jsonextractkey jsonextractscalar JSONFORMAT JSONPATH JSONPATHARRAY JSONPATHARRAYDEFAULTEMPTY JSONPATHDOUBLE JSONPATHLONG JSONPATHSTRING length ln lower lpad ltrim max MAXMV MD5 millisecond min minmaxrange MINMAXRANGEMV MINMV minute MOD mode month mult now percentile percentileest percentileestmv percentiletdigest percentiletdigestmv percentilemv percentilekll percentilerawkll percentilekllmv percentilerawkllmv quarter regexpExtract remove replace reverse round

rpad rtrim second SEGMENTPARTITIONEDDISTINCTCOUNT sha sha256 sha512 sqrt startswith ST_AsBinary ST_AsText ST_Contains ST_Distance ST_GeogFromText ST_GeogFromWKB ST_GeometryType ST_GeomFromText ST_GeomFromWKB STPOINT ST_Polygon strpos ST_Union SUB substr sum TIMECONVERT https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/timezoneHour.md https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/timezoneMinute.md ToDateTime https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/toEpoch.md https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/toEpochBucket.md https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/toEpochRounded.md TOJSONMAPSTR toSphericalGeography trim upper Url UTF8 VALUEIN week year https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/yearOfWeek.md

PreviousMonitoring Metrics NextABS