⌘Ctrlk

Introduction
- Import Data
Window Functions
Function List
- Contribute Pinot documentation
- Style guide

Powered by GitBook

For the complete documentation index, see llms.txt. This page is also available as Markdown.

Function List

This page is deprecating, we are moving all the below functions into the relevant categories in this section.

Since the functions are too many and there is not point to make a full list here just for function name checking.

We decided to segregate functions into its usage and re-organize them.

This page contains reference documentation for functions in Apache Pinot.

ABS ADD ARRAY_AGG 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 DISTINCTCOUNTBITMAPMV DISTINCTCOUNTHLL DISTINCTCOUNTHLLMV 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 GridDistance 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_AsGeoJSON ST_AsText ST_Contains ST_Distance ST_GeogFromGeoJSON ST_GeogFromText ST_GeogFromWKB ST_GeometryType ST_GeomFromGeoJSON 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

PreviousWindow Functions NextABS

Was this helpful?

Was this helpful?