# Functions

This page contains reference documentation for functions in Apache Pinot.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

{% content-ref url="/pages/QMwInmYBQbAIvEm5kThc" %}
[yearOfWeek](/release-0.10.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-0.10.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.