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 https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/clpdecode.md codepoint concat count COUNTMV DATETIMECONVERT DATETRUNC day dayOfWeek dayOfYear DISTINCT DISTINCTCOUNT DISTINCTCOUNTBITMAP DISTINCTCOUNTHLLMV DISTINCTCOUNTHLL DISTINCTCOUNTBITMAPMV https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcounthllplus.md https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcounthllplusmv.md DISTINCTCOUNTMV DISTINCTCOUNTRAWHLL https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawhllplus.md DISTINCTCOUNTRAWHLLMV https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawhllplusmv.md https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawcpcsketch.md DISTINCTCOUNTRAWTHETASKETCH DISTINCTCOUNTRAWHLL DISTINCTCOUNTTHETASKETCH DISTINCTCOUNTTHETASKETCH DISTINCTCOUNTHLL DISTINCTSUM DISTINCTSUMMV DIV exp Extract FIRSTWITHTIME FrequentLongsSketch FrequentStringsSketch FromDateTime FLOOR FromEpoch FromEpochBucket Histogram hour jsonextractkey jsonextractscalar JSONFORMAT JSONPATH JSONPATHARRAY JSONPATHARRAYDEFAULTEMPTY JSONPATHDOUBLE JSONPATHLONG JSONPATHSTRING LAG LASTWITHTIME LEAD 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 ROW_NUMBER 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 summv TIMECONVERT timezoneHour timezoneMinute ToDateTime ToEpoch ToEpochBucket ToEpochRounded TOJSONMAPSTR toSphericalGeography trim upper Url UTF8 VALUEIN week year yearOfWeek

PreviousMonitoring Metrics NextABS