release-1.1.0
latest
release-1.2.0
release-1.1.0
release-1.0.0
release-0.12.1
release-0.12.0
release-0.11.0
release-0.10.0
release-0.9.0
release-0.4.0
Ask or search...
Ctrl + K
Configuration Reference
Functions
This page contains reference documentation for functions in Apache Pinot.
Previous
Monitoring Metrics
Next
ABS
This page contains reference documentation for functions in Apache Pinot.
https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/avgvalueintegersumtuplesketch.md
https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/clpdecode.md
https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawcpcsketch.md
https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawintegersumtuplesketch.md
https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawull.md
https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountcpcsketch.md
https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcounttuplesketch.md
https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountull.md
https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/freqeuentlongssketch.md
https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/frequentstringsketch.md
https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/sumvaluesintegersumtuplesketch.md
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
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
https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/yearOfWeek.md
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
FIRSTWITHTIME
FromDateTime
FLOOR
FromEpoch
FromEpochBucket
Histogram
hour
jsonextractkey
jsonextractscalar
JSONFORMAT
JSONPATH
JSONPATHARRAY
JSONPATHARRAYDEFAULTEMPTY
JSONPATHDOUBLE
JSONPATHLONG
JSONPATHSTRING
LASTWITHTIME
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
TIMECONVERT
ToDateTime
TOJSONMAPSTR
toSphericalGeography
trim
upper
Url
UTF8
VALUEIN
week
year
