Functions

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

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

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

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