# Functions

This page contains reference documentation for functions in Apache Pinot.

{% content-ref url="/pages/6hGvLhqflnfc4usiKDyh" %}
[ABS](/release-1.2.0/configuration-reference/functions/abs.md)
{% endcontent-ref %}

{% content-ref url="/pages/P9aVMQJS2RbsSCj4kZ7S" %}
[ADD](/release-1.2.0/configuration-reference/functions/add.md)
{% endcontent-ref %}

{% content-ref url="/pages/4IdPO9qVzX2O9ZAJ5pw5" %}
[arrayConcatDouble](/release-1.2.0/configuration-reference/functions/arrayconcatdouble.md)
{% endcontent-ref %}

{% content-ref url="/pages/MST9TNz2hCQeLbwwipQm" %}
[arrayConcatFloat](/release-1.2.0/configuration-reference/functions/arrayconcatfloat.md)
{% endcontent-ref %}

{% content-ref url="/pages/eMQVk1Q7ZW6y3DZOuu6M" %}
[arrayConcatInt](/release-1.2.0/configuration-reference/functions/arrayconcatint.md)
{% endcontent-ref %}

{% content-ref url="/pages/qNfKKBrEgSpwdlHBUd1z" %}
[arrayConcatLong](/release-1.2.0/configuration-reference/functions/arrayconcatlong.md)
{% endcontent-ref %}

{% content-ref url="/pages/bMLk2TgzigJe34vR38hO" %}
[arrayConcatString](/release-1.2.0/configuration-reference/functions/arrayconcatstring.md)
{% endcontent-ref %}

{% content-ref url="/pages/AgCKzui2gaeAyjnhZCcL" %}
[arrayContainsInt](/release-1.2.0/configuration-reference/functions/arraycontainsint.md)
{% endcontent-ref %}

{% content-ref url="/pages/y71bFTeEozMBBVdAFhgL" %}
[arrayContainsString](/release-1.2.0/configuration-reference/functions/arraycontainsstring.md)
{% endcontent-ref %}

{% content-ref url="/pages/so4DVxZm2F2RXjC6tSwj" %}
[arrayDistinctInt](/release-1.2.0/configuration-reference/functions/arraydistinctint.md)
{% endcontent-ref %}

{% content-ref url="/pages/myEkiqTw1qHn6x8LFbi5" %}
[arrayDistinctString](/release-1.2.0/configuration-reference/functions/arraydistinctstring.md)
{% endcontent-ref %}

{% content-ref url="/pages/uRFCfWn1CeFyufTmzNLR" %}
[arrayIndexOfInt](/release-1.2.0/configuration-reference/functions/arrayindexofint.md)
{% endcontent-ref %}

{% content-ref url="/pages/ztiC1SvPY6QCZu3uVOkc" %}
[arrayIndexOfString](/release-1.2.0/configuration-reference/functions/arrayindexofstring.md)
{% endcontent-ref %}

{% content-ref url="/pages/NXwFQVUX5INOu9RkLGrf" %}
[ARRAYLENGTH](/release-1.2.0/configuration-reference/functions/arraylength.md)
{% endcontent-ref %}

{% content-ref url="/pages/CyFOuNFtBV47HCeC63M8" %}
[arrayRemoveInt](/release-1.2.0/configuration-reference/functions/arrayremoveint.md)
{% endcontent-ref %}

{% content-ref url="/pages/ns4QOMdHPSYLf47iOec1" %}
[arrayRemoveString](/release-1.2.0/configuration-reference/functions/arrayremovestring.md)
{% endcontent-ref %}

{% content-ref url="/pages/EJtEi9Notf139HHONAc9" %}
[arrayReverseInt](/release-1.2.0/configuration-reference/functions/arrayreverseint.md)
{% endcontent-ref %}

{% content-ref url="/pages/l9Z5iq2ZkC5bgGbqlrhK" %}
[arrayReverseString](/release-1.2.0/configuration-reference/functions/arrayreversestring.md)
{% endcontent-ref %}

{% content-ref url="/pages/fhhTABAviQzAGYY8gOoo" %}
[arraySliceInt](/release-1.2.0/configuration-reference/functions/arraysliceint.md)
{% endcontent-ref %}

{% content-ref url="/pages/mGE3YsK5OQdcmPcl8N5W" %}
[arraySliceString](/release-1.2.0/configuration-reference/functions/arrayslicestring.md)
{% endcontent-ref %}

{% content-ref url="/pages/cjeRkXnArV900d1XZwhF" %}
[arraySortInt](/release-1.2.0/configuration-reference/functions/arraysortint.md)
{% endcontent-ref %}

{% content-ref url="/pages/oUTIU8ZKjVUBrGuVhe96" %}
[arraySortString](/release-1.2.0/configuration-reference/functions/arraysortstring.md)
{% endcontent-ref %}

{% content-ref url="/pages/di72jMSFyNWn8xTFl3SL" %}
[arrayUnionInt](/release-1.2.0/configuration-reference/functions/arrayunionint.md)
{% endcontent-ref %}

{% content-ref url="/pages/Swa6R7GiE5kUVnj347Xx" %}
[arrayUnionString](/release-1.2.0/configuration-reference/functions/arrayunionstring.md)
{% endcontent-ref %}

{% content-ref url="/pages/YledVSmtUvmTMm8RqRQR" %}
[AVGMV](/release-1.2.0/configuration-reference/functions/avgmv.md)
{% endcontent-ref %}

{% content-ref url="/pages/vGPuqjvtrb6yx4SwwLtj" %}
[Base64](/release-1.2.0/configuration-reference/functions/base64.md)
{% endcontent-ref %}

{% content-ref url="/pages/M60WFStGtKwJXgbzJa9f" %}
[caseWhen](/release-1.2.0/configuration-reference/functions/casewhen.md)
{% endcontent-ref %}

{% content-ref url="/pages/NpQqg4GTCv486S9U4jxk" %}
[ceil](/release-1.2.0/configuration-reference/functions/ceil.md)
{% endcontent-ref %}

{% content-ref url="/pages/9Sc227F4ZYVFSz1Vh9bZ" %}
[CHR](/release-1.2.0/configuration-reference/functions/chr.md)
{% endcontent-ref %}

{% content-ref url="<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/clpdecode.md>
{% endcontent-ref %}

{% content-ref url="/pages/sG9rabb2GR9ivUBigCME" %}
[codepoint](/release-1.2.0/configuration-reference/functions/codepoint.md)
{% endcontent-ref %}

{% content-ref url="/pages/XljNRoZVrdGR8k1LoQEK" %}
[concat](/release-1.2.0/configuration-reference/functions/concat.md)
{% endcontent-ref %}

{% content-ref url="/pages/ug30yDRsQMVsS8YWDmEA" %}
[count](/release-1.2.0/configuration-reference/functions/count.md)
{% endcontent-ref %}

{% content-ref url="/pages/WBpQbDdvDzKTfJ07JPm5" %}
[COUNTMV](/release-1.2.0/configuration-reference/functions/countmv.md)
{% endcontent-ref %}

{% content-ref url="/pages/WPNh07FTBLetf8F5Kxg0" %}
[DATETIMECONVERT](/release-1.2.0/configuration-reference/functions/datetimeconvert.md)
{% endcontent-ref %}

{% content-ref url="/pages/qqN0dLEVswQwiatBuK1h" %}
[DATETRUNC](/release-1.2.0/configuration-reference/functions/datetrunc.md)
{% endcontent-ref %}

{% content-ref url="/pages/1DbaTQEenoWtJ1rWGidK" %}
[day](/release-1.2.0/configuration-reference/functions/day.md)
{% endcontent-ref %}

{% content-ref url="/pages/lPKj2gIJcdfhvUGooqjU" %}
[dayOfWeek](/release-1.2.0/configuration-reference/functions/dayofweek.md)
{% endcontent-ref %}

{% content-ref url="/pages/r3SXeXlUky1ovcXsIskK" %}
[dayOfYear](/release-1.2.0/configuration-reference/functions/dayofyear.md)
{% endcontent-ref %}

{% content-ref url="/pages/6PDmoBnV9fee7qV6oQzR" %}
[DISTINCT](/release-1.2.0/configuration-reference/functions/distinct.md)
{% endcontent-ref %}

{% content-ref url="/pages/DHfNzdIexSJ2eJCRsS2I" %}
[DISTINCTCOUNT](/release-1.2.0/configuration-reference/functions/distinctcount.md)
{% endcontent-ref %}

{% content-ref url="/pages/R2PgxPIqEeVwHnf6srRm" %}
[DISTINCTCOUNTBITMAP](/release-1.2.0/configuration-reference/functions/distinctcountbitmap.md)
{% endcontent-ref %}

{% content-ref url="/pages/AQ41oJ4HaerxDKKR0LCC" %}
[DISTINCTCOUNTHLLMV](/release-1.2.0/configuration-reference/functions/distinctcountbitmapmv.md)
{% endcontent-ref %}

{% content-ref url="/pages/02HXF0YDxs85otMn3hqS" %}
[DISTINCTCOUNTHLL](/release-1.2.0/configuration-reference/functions/distinctcounthll.md)
{% endcontent-ref %}

{% content-ref url="/pages/IUQczawlQxsSPWHXk6Pt" %}
[DISTINCTCOUNTBITMAPMV](/release-1.2.0/configuration-reference/functions/distinctcounthllmv.md)
{% endcontent-ref %}

{% content-ref url="<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/distinctcounthllplus.md>
{% endcontent-ref %}

{% content-ref url="<https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcounthllplusmv.md>" %}
<https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcounthllplusmv.md>
{% endcontent-ref %}

{% content-ref url="/pages/FdUVbFRgDIV3kBLNuWeC" %}
[DISTINCTCOUNTMV](/release-1.2.0/configuration-reference/functions/distinctcountmv.md)
{% endcontent-ref %}

{% content-ref url="/pages/DbEzSk0NYT09ny6eZKJe" %}
[DISTINCTCOUNTRAWHLL](/release-1.2.0/configuration-reference/functions/distinctcountrawhll.md)
{% endcontent-ref %}

{% content-ref url="<https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawhllplus.md>" %}
<https://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawhllplus.md>
{% endcontent-ref %}

{% content-ref url="/pages/mwOfnfy3fpYbAhKyQrRr" %}
[DISTINCTCOUNTRAWHLLMV](/release-1.2.0/configuration-reference/functions/distinctcountrawhllmv.md)
{% endcontent-ref %}

{% content-ref url="<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/distinctcountrawhllplusmv.md>
{% endcontent-ref %}

{% content-ref url="<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/distinctcountrawcpcsketch.md>
{% endcontent-ref %}

{% content-ref url="/pages/HnCH2zkxbX1tg7Fu8i48" %}
[DISTINCTCOUNTRAWTHETASKETCH](/release-1.2.0/configuration-reference/functions/distinctcountrawthetasketch.md)
{% endcontent-ref %}

{% content-ref url="/pages/DbEzSk0NYT09ny6eZKJe" %}
[DISTINCTCOUNTRAWHLL](/release-1.2.0/configuration-reference/functions/distinctcountrawhll.md)
{% endcontent-ref %}

{% content-ref url="/pages/t6H2hRYHeBoEgU6RTIpM" %}
[DISTINCTCOUNTTHETASKETCH](/release-1.2.0/configuration-reference/functions/distinctcountthetasketch.md)
{% endcontent-ref %}

{% content-ref url="/pages/t6H2hRYHeBoEgU6RTIpM" %}
[DISTINCTCOUNTTHETASKETCH](/release-1.2.0/configuration-reference/functions/distinctcountthetasketch.md)
{% endcontent-ref %}

{% content-ref url="/pages/02HXF0YDxs85otMn3hqS" %}
[DISTINCTCOUNTHLL](/release-1.2.0/configuration-reference/functions/distinctcounthll.md)
{% endcontent-ref %}

{% content-ref url="/pages/lbXoKVXz7Vy85mMxSlf5" %}
[DISTINCTSUM](/release-1.2.0/configuration-reference/functions/distinctsum.md)
{% endcontent-ref %}

{% content-ref url="/pages/9UCJRYsldSJx5WO3IXb4" %}
[DISTINCTSUMMV](/release-1.2.0/configuration-reference/functions/distinctsummv.md)
{% endcontent-ref %}

{% content-ref url="/pages/RMOfTV5ETNvkXd0dJ4r2" %}
[DIV](/release-1.2.0/configuration-reference/functions/div.md)
{% endcontent-ref %}

{% content-ref url="/pages/L7mHL5eGxfVTNjJSe9Kc" %}
[exp](/release-1.2.0/configuration-reference/functions/exp.md)
{% endcontent-ref %}

{% content-ref url="/pages/fqiOIqM630rGdXNwYTaS" %}
[Extract](/release-1.2.0/configuration-reference/functions/extract.md)
{% endcontent-ref %}

{% content-ref url="/pages/nx8Y6J2rXPZ7Eri1uaO5" %}
[FIRSTWITHTIME](/release-1.2.0/configuration-reference/functions/firstwithtime.md)
{% endcontent-ref %}

{% content-ref url="/pages/wzumfCAOPLPcuakQ9X1Y" %}
[FrequentLongsSketch](/release-1.2.0/configuration-reference/functions/frequentlongssketch.md)
{% endcontent-ref %}

{% content-ref url="/pages/yjOpvk2OaxZKLvk8RrwQ" %}
[FrequentStringsSketch](/release-1.2.0/configuration-reference/functions/frequentstringssketch.md)
{% endcontent-ref %}

{% content-ref url="/pages/RQWrAV8RxLe5x8EfZstv" %}
[FromDateTime](/release-1.2.0/configuration-reference/functions/fromdatetime.md)
{% endcontent-ref %}

{% content-ref url="/pages/uP2nNAzWWKKMlq8SHHrP" %}
[FLOOR](/release-1.2.0/configuration-reference/functions/floor.md)
{% endcontent-ref %}

{% content-ref url="/pages/Re4f07JchzwgKtf3H8F7" %}
[FromEpoch](/release-1.2.0/configuration-reference/functions/fromepoch.md)
{% endcontent-ref %}

{% content-ref url="/pages/h9LOxu4rbkRogeX9yOFe" %}
[FromEpochBucket](/release-1.2.0/configuration-reference/functions/fromepochbucket.md)
{% endcontent-ref %}

{% content-ref url="/pages/WAh96ZtBvNCMscB2unAs" %}
[Histogram](/release-1.2.0/configuration-reference/functions/histogram.md)
{% endcontent-ref %}

{% content-ref url="/pages/PXBmDhfTqRMqMMbjabgv" %}
[hour](/release-1.2.0/configuration-reference/functions/hour.md)
{% endcontent-ref %}

{% content-ref url="/pages/XWkwY4003qqmBxTqcG74" %}
[jsonextractkey](/release-1.2.0/configuration-reference/functions/jsonextractkey.md)
{% endcontent-ref %}

{% content-ref url="/pages/g0dL9tRwolVVu3Y2Ptp4" %}
[jsonextractscalar](/release-1.2.0/configuration-reference/functions/jsonextractscalar.md)
{% endcontent-ref %}

{% content-ref url="/pages/Rjb1yMkydC0cxjf8od4K" %}
[JSONFORMAT](/release-1.2.0/configuration-reference/functions/jsonformat.md)
{% endcontent-ref %}

{% content-ref url="/pages/qASdU729zp0CPvjpRslo" %}
[JSONPATH](/release-1.2.0/configuration-reference/functions/jsonpath.md)
{% endcontent-ref %}

{% content-ref url="/pages/549bmlL3gFAw51j0xaMr" %}
[JSONPATHARRAY](/release-1.2.0/configuration-reference/functions/jsonpatharray.md)
{% endcontent-ref %}

{% content-ref url="/pages/ywVDH7HksFWnnbkDem72" %}
[JSONPATHARRAYDEFAULTEMPTY](/release-1.2.0/configuration-reference/functions/jsonpatharraydefaultempty.md)
{% endcontent-ref %}

{% content-ref url="/pages/F2V1wPybp6ovhV3AxRxA" %}
[JSONPATHDOUBLE](/release-1.2.0/configuration-reference/functions/jsonpathdouble.md)
{% endcontent-ref %}

{% content-ref url="/pages/wgRUKYcSG94iKtrHiF0b" %}
[JSONPATHLONG](/release-1.2.0/configuration-reference/functions/jsonpathlong.md)
{% endcontent-ref %}

{% content-ref url="/pages/2QIBzFjZwBG0jsZxGAKO" %}
[JSONPATHSTRING](/release-1.2.0/configuration-reference/functions/jsonpathstring.md)
{% endcontent-ref %}

{% content-ref url="/pages/3gEFpPaskWa2RD39dtlF" %}
[LAG](/release-1.2.0/configuration-reference/functions/lag.md)
{% endcontent-ref %}

{% content-ref url="/pages/MwCNGobPRmUKFBBNT9Wl" %}
[LASTWITHTIME](/release-1.2.0/configuration-reference/functions/lastwithtime.md)
{% endcontent-ref %}

{% content-ref url="/pages/IulaJAYGhWb1KnWnku5x" %}
[LEAD](/release-1.2.0/configuration-reference/functions/lead.md)
{% endcontent-ref %}

{% content-ref url="/pages/UjGi3Ua7hlkOXcURU3HZ" %}
[length](/release-1.2.0/configuration-reference/functions/length.md)
{% endcontent-ref %}

{% content-ref url="/pages/6GOcKWJFa6vqPYWzr0Uc" %}
[ln](/release-1.2.0/configuration-reference/functions/ln.md)
{% endcontent-ref %}

{% content-ref url="/pages/zTy0KsrZ1CAdKHpwwTNu" %}
[lower](/release-1.2.0/configuration-reference/functions/lower.md)
{% endcontent-ref %}

{% content-ref url="/pages/F4qP7L55GFhceDWCmAKa" %}
[lpad](/release-1.2.0/configuration-reference/functions/lpad.md)
{% endcontent-ref %}

{% content-ref url="/pages/sdUghpWYuVbUflIbbeuF" %}
[ltrim](/release-1.2.0/configuration-reference/functions/ltrim.md)
{% endcontent-ref %}

{% content-ref url="/pages/CDgKoI7S8pNAeUngNhM0" %}
[max](/release-1.2.0/configuration-reference/functions/max.md)
{% endcontent-ref %}

{% content-ref url="/pages/pseSnWq0odHLNLwU2TvJ" %}
[MAXMV](/release-1.2.0/configuration-reference/functions/maxmv.md)
{% endcontent-ref %}

{% content-ref url="/pages/OBaijc6gWmXBhStFazmr" %}
[MD5](/release-1.2.0/configuration-reference/functions/md5.md)
{% endcontent-ref %}

{% content-ref url="/pages/eMcEDoxrdYkX725gHzPs" %}
[millisecond](/release-1.2.0/configuration-reference/functions/millisecond.md)
{% endcontent-ref %}

{% content-ref url="/pages/wlDnJTXnwH7TIBY4G90J" %}
[min](/release-1.2.0/configuration-reference/functions/min.md)
{% endcontent-ref %}

{% content-ref url="/pages/o2RhLip6QTP8ChzhBDum" %}
[minmaxrange](/release-1.2.0/configuration-reference/functions/minmaxrange.md)
{% endcontent-ref %}

{% content-ref url="/pages/gdKHGGrlLB8KvOXopok3" %}
[MINMAXRANGEMV](/release-1.2.0/configuration-reference/functions/minmaxrangemv.md)
{% endcontent-ref %}

{% content-ref url="/pages/1q1MkLzvWKQQLQ2D5cb0" %}
[MINMV](/release-1.2.0/configuration-reference/functions/minmv.md)
{% endcontent-ref %}

{% content-ref url="/pages/KIIqTM5qx09uY0Po3FPr" %}
[minute](/release-1.2.0/configuration-reference/functions/minute.md)
{% endcontent-ref %}

{% content-ref url="/pages/jMWJ5L2hGcZFQSURFF4j" %}
[MOD](/release-1.2.0/configuration-reference/functions/mod.md)
{% endcontent-ref %}

{% content-ref url="/pages/6LmuQ4uiuzYw5Gg8vKw2" %}
[mode](/release-1.2.0/configuration-reference/functions/mode.md)
{% endcontent-ref %}

{% content-ref url="/pages/rD7RYPJsMjLULSHPa3vC" %}
[month](/release-1.2.0/configuration-reference/functions/month.md)
{% endcontent-ref %}

{% content-ref url="/pages/KIMZDxBh0PVtrVLoNeXK" %}
[mult](/release-1.2.0/configuration-reference/functions/mult.md)
{% endcontent-ref %}

{% content-ref url="/pages/a2hHaoL3pQHNCpjwDkkj" %}
[now](/release-1.2.0/configuration-reference/functions/now.md)
{% endcontent-ref %}

{% content-ref url="/pages/CDC8OWgAUyuzrLHdQNnl" %}
[percentile](/release-1.2.0/configuration-reference/functions/percentile.md)
{% endcontent-ref %}

{% content-ref url="/pages/1B6eFhbiDfEq9aUgjhyA" %}
[percentileest](/release-1.2.0/configuration-reference/functions/percentileest.md)
{% endcontent-ref %}

{% content-ref url="/pages/2C563OYQAmpOdOdhTjom" %}
[percentileestmv](/release-1.2.0/configuration-reference/functions/percentileestmv.md)
{% endcontent-ref %}

{% content-ref url="/pages/H9Ttk9mTFhFqRMmBZEhF" %}
[percentiletdigest](/release-1.2.0/configuration-reference/functions/percentiletdigest.md)
{% endcontent-ref %}

{% content-ref url="/pages/I2nQFK8pTj0tMngRNqFP" %}
[percentiletdigestmv](/release-1.2.0/configuration-reference/functions/percentiletdigestmv.md)
{% endcontent-ref %}

{% content-ref url="/pages/MLITDstQTlti92S6tHPp" %}
[percentilemv](/release-1.2.0/configuration-reference/functions/percentilemv.md)
{% endcontent-ref %}

{% content-ref url="/pages/rrRBivpi0L6BfkHUDD0N" %}
[percentilekll](/release-1.2.0/configuration-reference/functions/percentilekll.md)
{% endcontent-ref %}

{% content-ref url="/pages/K1FqQ8pVziBgYpd3k6hh" %}
[percentilerawkll](/release-1.2.0/configuration-reference/functions/percentilerawkll.md)
{% endcontent-ref %}

{% content-ref url="/pages/Ho5OAlbjTYkr1TgUcbgO" %}
[percentilekllmv](/release-1.2.0/configuration-reference/functions/percentilekllmv.md)
{% endcontent-ref %}

{% content-ref url="/pages/f1BpdQJwPA3ALlBxKzAi" %}
[percentilerawkllmv](/release-1.2.0/configuration-reference/functions/percentilerawkllmv.md)
{% endcontent-ref %}

{% content-ref url="/pages/3JoFiManh3i6fsMjBxML" %}
[quarter](/release-1.2.0/configuration-reference/functions/quarter.md)
{% endcontent-ref %}

{% content-ref url="/pages/UuzqcdvpSikcYhApyYwy" %}
[regexpExtract](/release-1.2.0/configuration-reference/functions/regexpextract.md)
{% endcontent-ref %}

{% content-ref url="/pages/3H0KNSnbTVf2kYFN5t5V" %}
[remove](/release-1.2.0/configuration-reference/functions/remove.md)
{% endcontent-ref %}

{% content-ref url="/pages/VXwM9b79aXBwinUgmEkd" %}
[replace](/release-1.2.0/configuration-reference/functions/replace.md)
{% endcontent-ref %}

{% content-ref url="/pages/AC7QEaooqZhVhVt4DcVG" %}
[reverse](/release-1.2.0/configuration-reference/functions/reverse.md)
{% endcontent-ref %}

{% content-ref url="/pages/Pe6Jd3e0PkBoMPjL3k0O" %}
[round](/release-1.2.0/configuration-reference/functions/round.md)
{% endcontent-ref %}

{% content-ref url="/pages/Z7e7ql51NLUj1y3Ds5uj" %}
[ROW\_NUMBER](/release-1.2.0/configuration-reference/functions/round-1.md)
{% endcontent-ref %}

{% content-ref url="/pages/0YNo04A9tsnZYhJgmAqy" %}
[rpad](/release-1.2.0/configuration-reference/functions/rpad.md)
{% endcontent-ref %}

{% content-ref url="/pages/Yv7dU74d2juKAONaj9kA" %}
[rtrim](/release-1.2.0/configuration-reference/functions/rtrim.md)
{% endcontent-ref %}

{% content-ref url="/pages/JstDFGDQcsELtUisdzVI" %}
[second](/release-1.2.0/configuration-reference/functions/second.md)
{% endcontent-ref %}

{% content-ref url="/pages/r8ZLQIouMGjIQRMUWhiS" %}
[SEGMENTPARTITIONEDDISTINCTCOUNT](/release-1.2.0/configuration-reference/functions/segmentpartitioneddistinctcount.md)
{% endcontent-ref %}

{% content-ref url="/pages/ruq2GdTerYYAY41TkpZG" %}
[sha](/release-1.2.0/configuration-reference/functions/sha.md)
{% endcontent-ref %}

{% content-ref url="/pages/0lef71EGbExVmGaxwUFV" %}
[sha256](/release-1.2.0/configuration-reference/functions/sha256.md)
{% endcontent-ref %}

{% content-ref url="/pages/1UVoSJWnVm3QbobXZnCk" %}
[sha512](/release-1.2.0/configuration-reference/functions/sha512.md)
{% endcontent-ref %}

{% content-ref url="/pages/j5Iaridx38Bf91rqiX2e" %}
[sqrt](/release-1.2.0/configuration-reference/functions/sqrt.md)
{% endcontent-ref %}

{% content-ref url="/pages/75puN0y6zkbo9TjmL8nz" %}
[startswith](/release-1.2.0/configuration-reference/functions/startswith.md)
{% endcontent-ref %}

{% content-ref url="/pages/7ftz6HaH1xkvzSr1b764" %}
[ST\_AsBinary](/release-1.2.0/configuration-reference/functions/stasbinary.md)
{% endcontent-ref %}

{% content-ref url="/pages/c3kbc3DKSe6R4MIoGqoL" %}
[ST\_AsText](/release-1.2.0/configuration-reference/functions/stastext.md)
{% endcontent-ref %}

{% content-ref url="/pages/Lr3J8GV2RtOK3nrYNeN8" %}
[ST\_Contains](/release-1.2.0/configuration-reference/functions/stcontains.md)
{% endcontent-ref %}

{% content-ref url="/pages/zFRNdoSvREe0sLvTM2wX" %}
[ST\_Distance](/release-1.2.0/configuration-reference/functions/stdistance.md)
{% endcontent-ref %}

{% content-ref url="/pages/VnGZhzDhWWtIG8F59Nto" %}
[ST\_GeogFromText](/release-1.2.0/configuration-reference/functions/stgeogfromtext.md)
{% endcontent-ref %}

{% content-ref url="/pages/hVkmjSFtfLJGbqU41U3r" %}
[ST\_GeogFromWKB](/release-1.2.0/configuration-reference/functions/stgeogfromwkb.md)
{% endcontent-ref %}

{% content-ref url="/pages/7sN6UBgx6Y4zo42p0fwT" %}
[ST\_GeometryType](/release-1.2.0/configuration-reference/functions/stgeometrytype.md)
{% endcontent-ref %}

{% content-ref url="/pages/cdUejdINClBhojEGDqCf" %}
[ST\_GeomFromText](/release-1.2.0/configuration-reference/functions/stgeomfromtext.md)
{% endcontent-ref %}

{% content-ref url="/pages/0sV20DyRdtrsE1FkX50A" %}
[ST\_GeomFromWKB](/release-1.2.0/configuration-reference/functions/stgeomfromwkb.md)
{% endcontent-ref %}

{% content-ref url="/pages/Ra90wxRatL5Z6FNtoLK2" %}
[STPOINT](/release-1.2.0/configuration-reference/functions/stpoint.md)
{% endcontent-ref %}

{% content-ref url="/pages/DZqZBzNJTsiT1m8Ap1Rl" %}
[ST\_Polygon](/release-1.2.0/configuration-reference/functions/stpolygon.md)
{% endcontent-ref %}

{% content-ref url="/pages/uzvSDlXUtwLF9okkTAyX" %}
[strpos](/release-1.2.0/configuration-reference/functions/strpos.md)
{% endcontent-ref %}

{% content-ref url="/pages/AF2GaCybKmfbdLfP0CkT" %}
[ST\_Union](/release-1.2.0/configuration-reference/functions/stunion.md)
{% endcontent-ref %}

{% content-ref url="/pages/DaDhSozcOdyRIazC5JH4" %}
[SUB](/release-1.2.0/configuration-reference/functions/sub.md)
{% endcontent-ref %}

{% content-ref url="/pages/d9CVIo1zOy5mnC535GCr" %}
[substr](/release-1.2.0/configuration-reference/functions/substr.md)
{% endcontent-ref %}

{% content-ref url="/pages/LbYRgm7vNIo3WfWhGSrt" %}
[sum](/release-1.2.0/configuration-reference/functions/sum.md)
{% endcontent-ref %}

{% content-ref url="/pages/RUm9jl7jIzBDClMDFDuD" %}
[summv](/release-1.2.0/configuration-reference/functions/summv.md)
{% endcontent-ref %}

{% content-ref url="/pages/AZQNzfBbZhR39Naobt1I" %}
[TIMECONVERT](/release-1.2.0/configuration-reference/functions/timeconvert.md)
{% endcontent-ref %}

{% content-ref url="/pages/Fvs3Ewx0gGNbYD376Blk" %}
[timezoneHour](/release-1.2.0/configuration-reference/functions/timezonehour.md)
{% endcontent-ref %}

{% content-ref url="/pages/Nz4qCABzOHPu2KGsmMYZ" %}
[timezoneMinute](/release-1.2.0/configuration-reference/functions/timezoneminute.md)
{% endcontent-ref %}

{% content-ref url="/pages/WTO3UUHGw80ajsgBFlwm" %}
[ToDateTime](/release-1.2.0/configuration-reference/functions/todatetime.md)
{% endcontent-ref %}

{% content-ref url="/pages/Pn9QIf1a334fDaR4mnUO" %}
[ToEpoch](/release-1.2.0/configuration-reference/functions/toepoch.md)
{% endcontent-ref %}

{% content-ref url="/pages/z69l1VOtPqM0ExpAfPkG" %}
[ToEpochBucket](/release-1.2.0/configuration-reference/functions/toepochbucket.md)
{% endcontent-ref %}

{% content-ref url="/pages/1TTsTw57Ck5C60USjLXE" %}
[ToEpochRounded](/release-1.2.0/configuration-reference/functions/toepochrounded.md)
{% endcontent-ref %}

{% content-ref url="/pages/QLZGHHLVxy11icXOqaby" %}
[TOJSONMAPSTR](/release-1.2.0/configuration-reference/functions/tojsonmapstr.md)
{% endcontent-ref %}

{% content-ref url="/pages/hu66fG39L26fvXpoUMLv" %}
[toSphericalGeography](/release-1.2.0/configuration-reference/functions/tosphericalgeography.md)
{% endcontent-ref %}

{% content-ref url="/pages/4SktORblqwemnaM2kZdU" %}
[trim](/release-1.2.0/configuration-reference/functions/trim.md)
{% endcontent-ref %}

{% content-ref url="/pages/wTDfBlBLwDC5utVCIhBO" %}
[upper](/release-1.2.0/configuration-reference/functions/upper.md)
{% endcontent-ref %}

{% content-ref url="/pages/LeO1kbRRhojqlbnKE8KF" %}
[Url](/release-1.2.0/configuration-reference/functions/url.md)
{% endcontent-ref %}

{% content-ref url="/pages/S6SEcHURFTAzXzRdnRfj" %}
[UTF8](/release-1.2.0/configuration-reference/functions/utf8.md)
{% endcontent-ref %}

{% content-ref url="/pages/iWmplpoSMbtuCggJnTcV" %}
[VALUEIN](/release-1.2.0/configuration-reference/functions/valuein.md)
{% endcontent-ref %}

{% content-ref url="/pages/D7V17lFRLaLxznCX0w98" %}
[week](/release-1.2.0/configuration-reference/functions/week.md)
{% endcontent-ref %}

{% content-ref url="/pages/W9hxuWV5Cs4qQ8CfpS36" %}
[year](/release-1.2.0/configuration-reference/functions/year.md)
{% endcontent-ref %}

{% content-ref url="/pages/QMwInmYBQbAIvEm5kThc" %}
[yearOfWeek](/release-1.2.0/configuration-reference/functions/yearofweek.md)
{% endcontent-ref %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pinot.apache.org/release-1.2.0/configuration-reference/functions.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.