README.md

description
This page contains reference documentation for functions in Apache Pinot.

Functions

This page contains reference documentation for functions in Apache Pinot.

{% content-ref url="abs.md" %} abs.md {% endcontent-ref %}

{% content-ref url="add.md" %} add.md {% endcontent-ref %}

{% content-ref url="array_agg.md" %} array_agg.md {% endcontent-ref %}

{% content-ref url="arrayconcatdouble.md" %} arrayconcatdouble.md {% endcontent-ref %}

{% content-ref url="arrayconcatfloat.md" %} arrayconcatfloat.md {% endcontent-ref %}

{% content-ref url="arrayconcatint.md" %} arrayconcatint.md {% endcontent-ref %}

{% content-ref url="arrayconcatlong.md" %} arrayconcatlong.md {% endcontent-ref %}

{% content-ref url="arrayconcatstring.md" %} arrayconcatstring.md {% endcontent-ref %}

{% content-ref url="arraycontainsint.md" %} arraycontainsint.md {% endcontent-ref %}

{% content-ref url="arraycontainsstring.md" %} arraycontainsstring.md {% endcontent-ref %}

{% content-ref url="arraydistinctint.md" %} arraydistinctint.md {% endcontent-ref %}

{% content-ref url="arraydistinctstring.md" %} arraydistinctstring.md {% endcontent-ref %}

{% content-ref url="arrayindexofint.md" %} arrayindexofint.md {% endcontent-ref %}

{% content-ref url="arrayindexofstring.md" %} arrayindexofstring.md {% endcontent-ref %}

{% content-ref url="arraylength.md" %} arraylength.md {% endcontent-ref %}

{% content-ref url="arrayremoveint.md" %} arrayremoveint.md {% endcontent-ref %}

{% content-ref url="arrayremovestring.md" %} arrayremovestring.md {% endcontent-ref %}

{% content-ref url="arrayreverseint.md" %} arrayreverseint.md {% endcontent-ref %}

{% content-ref url="arrayreversestring.md" %} arrayreversestring.md {% endcontent-ref %}

{% content-ref url="arraysliceint.md" %} arraysliceint.md {% endcontent-ref %}

{% content-ref url="arrayslicestring.md" %} arrayslicestring.md {% endcontent-ref %}

{% content-ref url="arraysortint.md" %} arraysortint.md {% endcontent-ref %}

{% content-ref url="arraysortstring.md" %} arraysortstring.md {% endcontent-ref %}

{% content-ref url="arrayunionint.md" %} arrayunionint.md {% endcontent-ref %}

{% content-ref url="arrayunionstring.md" %} arrayunionstring.md {% endcontent-ref %}

{% content-ref url="avgmv.md" %} avgmv.md {% endcontent-ref %}

{% content-ref url="base64.md" %} base64.md {% endcontent-ref %}

{% content-ref url="caseWhen.md" %} caseWhen.md {% endcontent-ref %}

{% content-ref url="ceil.md" %} ceil.md {% endcontent-ref %}

{% content-ref url="chr.md" %} chr.md {% endcontent-ref %}

{% content-ref url="clpdecode.md" %} clpdecode.md {% endcontent-ref %}

{% content-ref url="codepoint.md" %} codepoint.md {% endcontent-ref %}

{% content-ref url="concat.md" %} concat.md {% endcontent-ref %}

{% content-ref url="count.md" %} count.md {% endcontent-ref %}

{% content-ref url="countmv.md" %} countmv.md {% endcontent-ref %}

{% content-ref url="datetimeconvert.md" %} datetimeconvert.md {% endcontent-ref %}

{% content-ref url="datetrunc.md" %} datetrunc.md {% endcontent-ref %}

{% content-ref url="day.md" %} day.md {% endcontent-ref %}

{% content-ref url="dayofweek.md" %} dayofweek.md {% endcontent-ref %}

{% content-ref url="dayofyear.md" %} dayofyear.md {% endcontent-ref %}

{% content-ref url="distinct.md" %} distinct.md {% endcontent-ref %}

{% content-ref url="distinctcount.md" %} distinctcount.md {% endcontent-ref %}

{% content-ref url="distinctcountbitmap.md" %} distinctcountbitmap.md {% endcontent-ref %}

{% content-ref url="distinctcountbitmapmv.md" %} distinctcountbitmapmv.md {% endcontent-ref %}

{% content-ref url="distinctcounthll.md" %} distinctcounthll.md {% endcontent-ref %}

{% content-ref url="distinctcounthllmv.md" %} distinctcounthllmv.md {% endcontent-ref %}

{% content-ref url="distinctcounthllplus.md" %} distinctcounthllplus.md {% endcontent-ref %}

{% content-ref url="distinctcounthllplusmv.md" %} distinctcounthllplusmv.md {% endcontent-ref %}

{% content-ref url="distinctcountmv.md" %} distinctcountmv.md {% endcontent-ref %}

{% content-ref url="distinctcountrawhll.md" %} distinctcountrawhll.md {% endcontent-ref %}

{% content-ref url="distinctcountrawhllplus.md" %} distinctcountrawhllplus.md {% endcontent-ref %}

{% content-ref url="distinctcountrawhllmv.md" %} distinctcountrawhllmv.md {% endcontent-ref %}

{% content-ref url="distinctcountrawhllplusmv.md" %} distinctcountrawhllplusmv.md {% endcontent-ref %}

{% content-ref url="distinctcountrawcpcsketch.md" %} distinctcountrawcpcsketch.md {% endcontent-ref %}

{% content-ref url="distinctcountrawthetasketch.md" %} distinctcountrawthetasketch.md {% endcontent-ref %}

{% content-ref url="distinctcountrawhll.md" %} distinctcountrawhll.md {% endcontent-ref %}

{% content-ref url="distinctcountthetasketch.md" %} distinctcountthetasketch.md {% endcontent-ref %}

{% content-ref url="distinctcountthetasketch.md" %} distinctcountthetasketch.md {% endcontent-ref %}

{% content-ref url="distinctcounthll.md" %} distinctcounthll.md {% endcontent-ref %}

{% content-ref url="distinctsum.md" %} distinctsum.md {% endcontent-ref %}

{% content-ref url="distinctsummv.md" %} distinctsummv.md {% endcontent-ref %}

{% content-ref url="div.md" %} div.md {% endcontent-ref %}

{% content-ref url="exp.md" %} exp.md {% endcontent-ref %}

{% content-ref url="extract.md" %} extract.md {% endcontent-ref %}

{% content-ref url="firstwithtime.md" %} firstwithtime.md {% endcontent-ref %}

{% content-ref url="frequentlongssketch.md" %} frequentlongssketch.md {% endcontent-ref %}

{% content-ref url="frequentstringssketch.md" %} frequentstringssketch.md {% endcontent-ref %}

{% content-ref url="fromdatetime.md" %} fromdatetime.md {% endcontent-ref %}

{% content-ref url="floor.md" %} floor.md {% endcontent-ref %}

{% content-ref url="fromepoch.md" %} fromepoch.md {% endcontent-ref %}

{% content-ref url="fromepochbucket.md" %} fromepochbucket.md {% endcontent-ref %}

{% content-ref url="histogram.md" %} histogram.md {% endcontent-ref %}

{% content-ref url="hour.md" %} hour.md {% endcontent-ref %}

{% content-ref url="jsonextractkey.md" %} jsonextractkey.md {% endcontent-ref %}

{% content-ref url="jsonextractscalar.md" %} jsonextractscalar.md {% endcontent-ref %}

{% content-ref url="jsonformat.md" %} jsonformat.md {% endcontent-ref %}

{% content-ref url="jsonpath.md" %} jsonpath.md {% endcontent-ref %}

{% content-ref url="jsonpatharray.md" %} jsonpatharray.md {% endcontent-ref %}

{% content-ref url="jsonpatharraydefaultempty.md" %} jsonpatharraydefaultempty.md {% endcontent-ref %}

{% content-ref url="jsonpathdouble.md" %} jsonpathdouble.md {% endcontent-ref %}

{% content-ref url="jsonpathlong.md" %} jsonpathlong.md {% endcontent-ref %}

{% content-ref url="jsonpathstring.md" %} jsonpathstring.md {% endcontent-ref %}

{% content-ref url="lag.md" %} lag.md {% endcontent-ref %}

{% content-ref url="lastwithtime.md" %} lastwithtime.md {% endcontent-ref %}

{% content-ref url="lead.md" %} lead.md {% endcontent-ref %}

{% content-ref url="length.md" %} length.md {% endcontent-ref %}

{% content-ref url="ln.md" %} ln.md {% endcontent-ref %}

{% content-ref url="lower.md" %} lower.md {% endcontent-ref %}

{% content-ref url="lpad.md" %} lpad.md {% endcontent-ref %}

{% content-ref url="ltrim.md" %} ltrim.md {% endcontent-ref %}

{% content-ref url="max.md" %} max.md {% endcontent-ref %}

{% content-ref url="maxmv.md" %} maxmv.md {% endcontent-ref %}

{% content-ref url="md5.md" %} md5.md {% endcontent-ref %}

{% content-ref url="millisecond.md" %} millisecond.md {% endcontent-ref %}

{% content-ref url="min.md" %} min.md {% endcontent-ref %}

{% content-ref url="minmaxrange.md" %} minmaxrange.md {% endcontent-ref %}

{% content-ref url="minmaxrangemv.md" %} minmaxrangemv.md {% endcontent-ref %}

{% content-ref url="minmv.md" %} minmv.md {% endcontent-ref %}

{% content-ref url="minute.md" %} minute.md {% endcontent-ref %}

{% content-ref url="mod.md" %} mod.md {% endcontent-ref %}

{% content-ref url="mode.md" %} mode.md {% endcontent-ref %}

{% content-ref url="month.md" %} month.md {% endcontent-ref %}

{% content-ref url="mult.md" %} mult.md {% endcontent-ref %}

{% content-ref url="now.md" %} now.md {% endcontent-ref %}

{% content-ref url="percentile.md" %} percentile.md {% endcontent-ref %}

{% content-ref url="percentileest.md" %} percentileest.md {% endcontent-ref %}

{% content-ref url="percentileestmv.md" %} percentileestmv.md {% endcontent-ref %}

{% content-ref url="percentiletdigest.md" %} percentiletdigest.md {% endcontent-ref %}

{% content-ref url="percentiletdigestmv.md" %} percentiletdigestmv.md {% endcontent-ref %}

{% content-ref url="percentilemv.md" %} percentilemv.md {% endcontent-ref %}

{% content-ref url="percentilekll.md" %} percentilekll.md {% endcontent-ref %}

{% content-ref url="percentilerawkll.md" %} percentilerawkll.md {% endcontent-ref %}

{% content-ref url="percentilekllmv.md" %} percentilekllmv.md {% endcontent-ref %}

{% content-ref url="percentilerawkllmv.md" %} percentilerawkllmv.md {% endcontent-ref %}

{% content-ref url="quarter.md" %} quarter.md {% endcontent-ref %}

{% content-ref url="regexpextract.md" %} regexpextract.md {% endcontent-ref %}

{% content-ref url="remove.md" %} remove.md {% endcontent-ref %}

{% content-ref url="replace.md" %} replace.md {% endcontent-ref %}

{% content-ref url="reverse.md" %} reverse.md {% endcontent-ref %}

{% content-ref url="round.md" %} round.md {% endcontent-ref %}

{% content-ref url="round-1-1.md" %} round-1-1.md {% endcontent-ref %}

{% content-ref url="rpad.md" %} rpad.md {% endcontent-ref %}

{% content-ref url="rtrim.md" %} rtrim.md {% endcontent-ref %}

{% content-ref url="second.md" %} second.md {% endcontent-ref %}

{% content-ref url="segmentpartitioneddistinctcount.md" %} segmentpartitioneddistinctcount.md {% endcontent-ref %}

{% content-ref url="sha.md" %} sha.md {% endcontent-ref %}

{% content-ref url="sha256.md" %} sha256.md {% endcontent-ref %}

{% content-ref url="sha512.md" %} sha512.md {% endcontent-ref %}

{% content-ref url="sqrt.md" %} sqrt.md {% endcontent-ref %}

{% content-ref url="startswith.md" %} startswith.md {% endcontent-ref %}

{% content-ref url="stasbinary.md" %} stasbinary.md {% endcontent-ref %}

{% content-ref url="st_asgeojson.md" %} st_asgeojson.md {% endcontent-ref %}

{% content-ref url="stastext.md" %} stastext.md {% endcontent-ref %}

{% content-ref url="stcontains.md" %} stcontains.md {% endcontent-ref %}

{% content-ref url="stdistance.md" %} stdistance.md {% endcontent-ref %}

{% content-ref url="st_geogfromgeojson.md" %} st_geogfromgeojson.md {% endcontent-ref %}

{% content-ref url="stgeogfromtext.md" %} stgeogfromtext.md {% endcontent-ref %}

{% content-ref url="stgeogfromwkb.md" %} stgeogfromwkb.md {% endcontent-ref %}

{% content-ref url="stgeometrytype.md" %} stgeometrytype.md {% endcontent-ref %}

{% content-ref url="st_geomfromgeojson.md" %} st_geomfromgeojson.md {% endcontent-ref %}

{% content-ref url="stgeomfromtext.md" %} stgeomfromtext.md {% endcontent-ref %}

{% content-ref url="stgeomfromwkb.md" %} stgeomfromwkb.md {% endcontent-ref %}

{% content-ref url="stpoint.md" %} stpoint.md {% endcontent-ref %}

{% content-ref url="stpolygon.md" %} stpolygon.md {% endcontent-ref %}

{% content-ref url="strpos.md" %} strpos.md {% endcontent-ref %}

{% content-ref url="stunion.md" %} stunion.md {% endcontent-ref %}

{% content-ref url="sub.md" %} sub.md {% endcontent-ref %}

{% content-ref url="substr.md" %} substr.md {% endcontent-ref %}

{% content-ref url="sum.md" %} sum.md {% endcontent-ref %}

{% content-ref url="summv.md" %} summv.md {% endcontent-ref %}

{% content-ref url="timeconvert.md" %} timeconvert.md {% endcontent-ref %}

{% content-ref url="timezonehour.md" %} timezonehour.md {% endcontent-ref %}

{% content-ref url="timezoneminute.md" %} timezoneminute.md {% endcontent-ref %}

{% content-ref url="todatetime.md" %} todatetime.md {% endcontent-ref %}

{% content-ref url="toepoch.md" %} toepoch.md {% endcontent-ref %}

{% content-ref url="toepochbucket.md" %} toepochbucket.md {% endcontent-ref %}

{% content-ref url="toepochrounded.md" %} toepochrounded.md {% endcontent-ref %}

{% content-ref url="tojsonmapstr.md" %} tojsonmapstr.md {% endcontent-ref %}

{% content-ref url="tosphericalgeography.md" %} tosphericalgeography.md {% endcontent-ref %}

{% content-ref url="trim.md" %} trim.md {% endcontent-ref %}

{% content-ref url="upper.md" %} upper.md {% endcontent-ref %}

{% content-ref url="url.md" %} url.md {% endcontent-ref %}

{% content-ref url="utf8.md" %} utf8.md {% endcontent-ref %}

{% content-ref url="valuein.md" %} valuein.md {% endcontent-ref %}

{% content-ref url="week.md" %} week.md {% endcontent-ref %}

{% content-ref url="year.md" %} year.md {% endcontent-ref %}

{% content-ref url="yearofweek.md" %} yearofweek.md {% endcontent-ref %}