Functions

This page contains reference documentation for functions in Apache Pinot.

This page contains reference documentation for functions in Apache Pinot.

ABS ADD arrayContainsInt arrayContainsString arrayDistinctInt arrayDistinctString arrayIndexOfInt arrayIndexOfString ARRAYLENGTH arrayRemoveInt arrayRemoveString arrayReverseInt arrayReverseString arraySliceInt arraySliceString arraySortInt arraySortString arrayUnionInt arrayUnionString AVGMV ceil CHR codepoint concat count COUNTMV DATETIMECONVERT DATETRUNC day dayOfWeek dayOfYear DISTINCT DISTINCTCOUNT DISTINCTCOUNTBITMAP DISTINCTCOUNTBITMAPMV DISTINCTCOUNTHLL DISTINCTCOUNTHLLMV DISTINCTCOUNTMV DISTINCTCOUNTRAWHLL DISTINCTCOUNTRAWHLLMV DISTINCTCOUNTRAWTHETASKETCH DISTINCTCOUNTTHETASKETCH DIV exp FromDateTime FLOOR FromEpoch FromEpochBucket 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 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 timezoneHour timezoneMinute ToDateTime ToEpoch ToEpochBucket ToEpochRounded TOJSONMAPSTR toSphericalGeography trim upper VALUEIN week year yearOfWeek

PreviousIngestion Job Spec NextABS

Last updated 2 years ago