⌘Ctrlk

Introduction

Powered by GitBook

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

Configuration Reference

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 ceil CHR codepoint concat count COUNTMV DATETIMECONVERT DATETRUNC day dayOfWeek dayOfYear DISTINCT DISTINCTCOUNT DISTINCTCOUNTBITMAP DISTINCTCOUNTHLLMV DISTINCTCOUNTHLL DISTINCTCOUNTBITMAPMV DISTINCTCOUNTMV DISTINCTCOUNTRAWHLL DISTINCTCOUNTRAWHLLMV DISTINCTCOUNTRAWTHETASKETCH DISTINCTCOUNTTHETASKETCH DIV exp 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 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

Last updated 3 years ago

Was this helpful?

Was this helpful?