# Functions

This page contains reference documentation for functions in Apache Pinot.

{% content-ref url="functions/abs" %}
[abs](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/abs)
{% endcontent-ref %}

{% content-ref url="functions/add" %}
[add](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/add)
{% endcontent-ref %}

{% content-ref url="functions/arrayconcatdouble" %}
[arrayconcatdouble](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayconcatdouble)
{% endcontent-ref %}

{% content-ref url="functions/arrayconcatfloat" %}
[arrayconcatfloat](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayconcatfloat)
{% endcontent-ref %}

{% content-ref url="functions/arrayconcatint" %}
[arrayconcatint](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayconcatint)
{% endcontent-ref %}

{% content-ref url="functions/arrayconcatlong" %}
[arrayconcatlong](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayconcatlong)
{% endcontent-ref %}

{% content-ref url="functions/arrayconcatstring" %}
[arrayconcatstring](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayconcatstring)
{% endcontent-ref %}

{% content-ref url="functions/arraycontainsint" %}
[arraycontainsint](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arraycontainsint)
{% endcontent-ref %}

{% content-ref url="functions/arraycontainsstring" %}
[arraycontainsstring](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arraycontainsstring)
{% endcontent-ref %}

{% content-ref url="functions/arraydistinctint" %}
[arraydistinctint](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arraydistinctint)
{% endcontent-ref %}

{% content-ref url="functions/arraydistinctstring" %}
[arraydistinctstring](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arraydistinctstring)
{% endcontent-ref %}

{% content-ref url="functions/arrayindexofint" %}
[arrayindexofint](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayindexofint)
{% endcontent-ref %}

{% content-ref url="functions/arrayindexofstring" %}
[arrayindexofstring](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayindexofstring)
{% endcontent-ref %}

{% content-ref url="functions/arraylength" %}
[arraylength](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arraylength)
{% endcontent-ref %}

{% content-ref url="functions/arrayremoveint" %}
[arrayremoveint](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayremoveint)
{% endcontent-ref %}

{% content-ref url="functions/arrayremovestring" %}
[arrayremovestring](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayremovestring)
{% endcontent-ref %}

{% content-ref url="functions/arrayreverseint" %}
[arrayreverseint](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayreverseint)
{% endcontent-ref %}

{% content-ref url="functions/arrayreversestring" %}
[arrayreversestring](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayreversestring)
{% endcontent-ref %}

{% content-ref url="functions/arraysliceint" %}
[arraysliceint](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arraysliceint)
{% endcontent-ref %}

{% content-ref url="functions/arrayslicestring" %}
[arrayslicestring](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayslicestring)
{% endcontent-ref %}

{% content-ref url="functions/arraysortint" %}
[arraysortint](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arraysortint)
{% endcontent-ref %}

{% content-ref url="functions/arraysortstring" %}
[arraysortstring](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arraysortstring)
{% endcontent-ref %}

{% content-ref url="functions/arrayunionint" %}
[arrayunionint](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayunionint)
{% endcontent-ref %}

{% content-ref url="functions/arrayunionstring" %}
[arrayunionstring](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/arrayunionstring)
{% endcontent-ref %}

{% content-ref url="functions/avgmv" %}
[avgmv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/avgmv)
{% endcontent-ref %}

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

{% content-ref url="functions/base64" %}
[base64](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/base64)
{% endcontent-ref %}

{% content-ref url="functions/casewhen" %}
[casewhen](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/casewhen)
{% endcontent-ref %}

{% content-ref url="functions/ceil" %}
[ceil](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/ceil)
{% endcontent-ref %}

{% content-ref url="functions/chr" %}
[chr](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/chr)
{% 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="functions/codepoint" %}
[codepoint](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/codepoint)
{% endcontent-ref %}

{% content-ref url="functions/concat" %}
[concat](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/concat)
{% endcontent-ref %}

{% content-ref url="functions/count" %}
[count](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/count)
{% endcontent-ref %}

{% content-ref url="functions/countmv" %}
[countmv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/countmv)
{% endcontent-ref %}

{% content-ref url="functions/datetimeconvert" %}
[datetimeconvert](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/datetimeconvert)
{% endcontent-ref %}

{% content-ref url="functions/datetrunc" %}
[datetrunc](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/datetrunc)
{% endcontent-ref %}

{% content-ref url="functions/day" %}
[day](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/day)
{% endcontent-ref %}

{% content-ref url="functions/dayofweek" %}
[dayofweek](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/dayofweek)
{% endcontent-ref %}

{% content-ref url="functions/dayofyear" %}
[dayofyear](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/dayofyear)
{% endcontent-ref %}

{% content-ref url="functions/distinct" %}
[distinct](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/distinct)
{% endcontent-ref %}

{% content-ref url="functions/distinctcount" %}
[distinctcount](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/distinctcount)
{% endcontent-ref %}

{% content-ref url="functions/distinctcountbitmap" %}
[distinctcountbitmap](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/distinctcountbitmap)
{% endcontent-ref %}

{% content-ref url="functions/distinctcountbitmapmv" %}
[distinctcountbitmapmv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/distinctcountbitmapmv)
{% endcontent-ref %}

{% content-ref url="functions/distinctcounthll" %}
[distinctcounthll](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/distinctcounthll)
{% endcontent-ref %}

{% content-ref url="functions/distinctcounthllmv" %}
[distinctcounthllmv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/distinctcounthllmv)
{% endcontent-ref %}

{% content-ref url="functions/distinctcountmv" %}
[distinctcountmv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/distinctcountmv)
{% endcontent-ref %}

{% content-ref url="functions/distinctcountrawhll" %}
[distinctcountrawhll](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/distinctcountrawhll)
{% endcontent-ref %}

{% content-ref url="functions/distinctcountrawhllmv" %}
[distinctcountrawhllmv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/distinctcountrawhllmv)
{% 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="functions/distinctcountrawthetasketch" %}
[distinctcountrawthetasketch](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/distinctcountrawthetasketch)
{% endcontent-ref %}

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

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

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

{% content-ref url="functions/distinctcountthetasketch" %}
[distinctcountthetasketch](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/distinctcountthetasketch)
{% endcontent-ref %}

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

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

{% content-ref url="functions/div" %}
[div](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/div)
{% endcontent-ref %}

{% content-ref url="functions/exp" %}
[exp](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/exp)
{% endcontent-ref %}

{% content-ref url="functions/extract" %}
[extract](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/extract)
{% endcontent-ref %}

{% content-ref url="functions/firstwithtime" %}
[firstwithtime](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/firstwithtime)
{% endcontent-ref %}

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

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

{% content-ref url="functions/fromdatetime" %}
[fromdatetime](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/fromdatetime)
{% endcontent-ref %}

{% content-ref url="functions/floor" %}
[floor](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/floor)
{% endcontent-ref %}

{% content-ref url="functions/fromepoch" %}
[fromepoch](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/fromepoch)
{% endcontent-ref %}

{% content-ref url="functions/fromepochbucket" %}
[fromepochbucket](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/fromepochbucket)
{% endcontent-ref %}

{% content-ref url="functions/histogram" %}
[histogram](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/histogram)
{% endcontent-ref %}

{% content-ref url="functions/hour" %}
[hour](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/hour)
{% endcontent-ref %}

{% content-ref url="functions/jsonextractkey" %}
[jsonextractkey](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/jsonextractkey)
{% endcontent-ref %}

{% content-ref url="functions/jsonextractscalar" %}
[jsonextractscalar](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/jsonextractscalar)
{% endcontent-ref %}

{% content-ref url="functions/jsonformat" %}
[jsonformat](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/jsonformat)
{% endcontent-ref %}

{% content-ref url="functions/jsonpath" %}
[jsonpath](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/jsonpath)
{% endcontent-ref %}

{% content-ref url="functions/jsonpatharray" %}
[jsonpatharray](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/jsonpatharray)
{% endcontent-ref %}

{% content-ref url="functions/jsonpatharraydefaultempty" %}
[jsonpatharraydefaultempty](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/jsonpatharraydefaultempty)
{% endcontent-ref %}

{% content-ref url="functions/jsonpathdouble" %}
[jsonpathdouble](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/jsonpathdouble)
{% endcontent-ref %}

{% content-ref url="functions/jsonpathlong" %}
[jsonpathlong](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/jsonpathlong)
{% endcontent-ref %}

{% content-ref url="functions/jsonpathstring" %}
[jsonpathstring](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/jsonpathstring)
{% endcontent-ref %}

{% content-ref url="functions/lastwithtime" %}
[lastwithtime](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/lastwithtime)
{% endcontent-ref %}

{% content-ref url="functions/length" %}
[length](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/length)
{% endcontent-ref %}

{% content-ref url="functions/ln" %}
[ln](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/ln)
{% endcontent-ref %}

{% content-ref url="functions/lower" %}
[lower](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/lower)
{% endcontent-ref %}

{% content-ref url="functions/lpad" %}
[lpad](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/lpad)
{% endcontent-ref %}

{% content-ref url="functions/ltrim" %}
[ltrim](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/ltrim)
{% endcontent-ref %}

{% content-ref url="functions/max" %}
[max](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/max)
{% endcontent-ref %}

{% content-ref url="functions/maxmv" %}
[maxmv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/maxmv)
{% endcontent-ref %}

{% content-ref url="functions/md5" %}
[md5](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/md5)
{% endcontent-ref %}

{% content-ref url="functions/millisecond" %}
[millisecond](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/millisecond)
{% endcontent-ref %}

{% content-ref url="functions/min" %}
[min](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/min)
{% endcontent-ref %}

{% content-ref url="functions/minmaxrange" %}
[minmaxrange](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/minmaxrange)
{% endcontent-ref %}

{% content-ref url="functions/minmaxrangemv" %}
[minmaxrangemv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/minmaxrangemv)
{% endcontent-ref %}

{% content-ref url="functions/minmv" %}
[minmv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/minmv)
{% endcontent-ref %}

{% content-ref url="functions/minute" %}
[minute](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/minute)
{% endcontent-ref %}

{% content-ref url="functions/mod" %}
[mod](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/mod)
{% endcontent-ref %}

{% content-ref url="functions/mode" %}
[mode](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/mode)
{% endcontent-ref %}

{% content-ref url="functions/month" %}
[month](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/month)
{% endcontent-ref %}

{% content-ref url="functions/mult" %}
[mult](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/mult)
{% endcontent-ref %}

{% content-ref url="functions/now" %}
[now](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/now)
{% endcontent-ref %}

{% content-ref url="functions/percentile" %}
[percentile](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/percentile)
{% endcontent-ref %}

{% content-ref url="functions/percentileest" %}
[percentileest](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/percentileest)
{% endcontent-ref %}

{% content-ref url="functions/percentileestmv" %}
[percentileestmv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/percentileestmv)
{% endcontent-ref %}

{% content-ref url="functions/percentiletdigest" %}
[percentiletdigest](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/percentiletdigest)
{% endcontent-ref %}

{% content-ref url="functions/percentiletdigestmv" %}
[percentiletdigestmv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/percentiletdigestmv)
{% endcontent-ref %}

{% content-ref url="functions/percentilemv" %}
[percentilemv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/percentilemv)
{% endcontent-ref %}

{% content-ref url="functions/percentilekll" %}
[percentilekll](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/percentilekll)
{% endcontent-ref %}

{% content-ref url="functions/percentilerawkll" %}
[percentilerawkll](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/percentilerawkll)
{% endcontent-ref %}

{% content-ref url="functions/percentilekllmv" %}
[percentilekllmv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/percentilekllmv)
{% endcontent-ref %}

{% content-ref url="functions/percentilerawkllmv" %}
[percentilerawkllmv](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/percentilerawkllmv)
{% endcontent-ref %}

{% content-ref url="functions/quarter" %}
[quarter](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/quarter)
{% endcontent-ref %}

{% content-ref url="functions/regexpextract" %}
[regexpextract](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/regexpextract)
{% endcontent-ref %}

{% content-ref url="functions/remove" %}
[remove](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/remove)
{% endcontent-ref %}

{% content-ref url="functions/replace" %}
[replace](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/replace)
{% endcontent-ref %}

{% content-ref url="functions/reverse" %}
[reverse](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/reverse)
{% endcontent-ref %}

{% content-ref url="functions/round" %}
[round](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/round)
{% endcontent-ref %}

{% content-ref url="functions/round-1" %}
[round-1](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/round-1)
{% endcontent-ref %}

{% content-ref url="functions/rpad" %}
[rpad](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/rpad)
{% endcontent-ref %}

{% content-ref url="functions/rtrim" %}
[rtrim](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/rtrim)
{% endcontent-ref %}

{% content-ref url="functions/second" %}
[second](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/second)
{% endcontent-ref %}

{% content-ref url="functions/segmentpartitioneddistinctcount" %}
[segmentpartitioneddistinctcount](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/segmentpartitioneddistinctcount)
{% endcontent-ref %}

{% content-ref url="functions/sha" %}
[sha](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/sha)
{% endcontent-ref %}

{% content-ref url="functions/sha256" %}
[sha256](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/sha256)
{% endcontent-ref %}

{% content-ref url="functions/sha512" %}
[sha512](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/sha512)
{% endcontent-ref %}

{% content-ref url="functions/sqrt" %}
[sqrt](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/sqrt)
{% endcontent-ref %}

{% content-ref url="functions/startswith" %}
[startswith](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/startswith)
{% endcontent-ref %}

{% content-ref url="functions/stasbinary" %}
[stasbinary](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stasbinary)
{% endcontent-ref %}

{% content-ref url="functions/stastext" %}
[stastext](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stastext)
{% endcontent-ref %}

{% content-ref url="functions/stcontains" %}
[stcontains](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stcontains)
{% endcontent-ref %}

{% content-ref url="functions/stdistance" %}
[stdistance](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stdistance)
{% endcontent-ref %}

{% content-ref url="functions/stgeogfromtext" %}
[stgeogfromtext](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stgeogfromtext)
{% endcontent-ref %}

{% content-ref url="functions/stgeogfromwkb" %}
[stgeogfromwkb](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stgeogfromwkb)
{% endcontent-ref %}

{% content-ref url="functions/stgeometrytype" %}
[stgeometrytype](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stgeometrytype)
{% endcontent-ref %}

{% content-ref url="functions/stgeomfromtext" %}
[stgeomfromtext](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stgeomfromtext)
{% endcontent-ref %}

{% content-ref url="functions/stgeomfromwkb" %}
[stgeomfromwkb](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stgeomfromwkb)
{% endcontent-ref %}

{% content-ref url="functions/stpoint" %}
[stpoint](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stpoint)
{% endcontent-ref %}

{% content-ref url="functions/stpolygon" %}
[stpolygon](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stpolygon)
{% endcontent-ref %}

{% content-ref url="functions/strpos" %}
[strpos](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/strpos)
{% endcontent-ref %}

{% content-ref url="functions/stunion" %}
[stunion](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/stunion)
{% endcontent-ref %}

{% content-ref url="functions/sub" %}
[sub](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/sub)
{% endcontent-ref %}

{% content-ref url="functions/substr" %}
[substr](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/substr)
{% endcontent-ref %}

{% content-ref url="functions/sum" %}
[sum](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/sum)
{% endcontent-ref %}

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

{% content-ref url="functions/timeconvert" %}
[timeconvert](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/timeconvert)
{% endcontent-ref %}

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

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

{% content-ref url="functions/todatetime" %}
[todatetime](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/todatetime)
{% endcontent-ref %}

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

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

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

{% content-ref url="functions/tojsonmapstr" %}
[tojsonmapstr](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/tojsonmapstr)
{% endcontent-ref %}

{% content-ref url="functions/tosphericalgeography" %}
[tosphericalgeography](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/tosphericalgeography)
{% endcontent-ref %}

{% content-ref url="functions/trim" %}
[trim](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/trim)
{% endcontent-ref %}

{% content-ref url="functions/upper" %}
[upper](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/upper)
{% endcontent-ref %}

{% content-ref url="functions/url" %}
[url](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/url)
{% endcontent-ref %}

{% content-ref url="functions/utf8" %}
[utf8](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/utf8)
{% endcontent-ref %}

{% content-ref url="functions/valuein" %}
[valuein](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/valuein)
{% endcontent-ref %}

{% content-ref url="functions/week" %}
[week](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/week)
{% endcontent-ref %}

{% content-ref url="functions/year" %}
[year](https://docs.pinot.apache.org/release-1.1.0/configuration-reference/functions/year)
{% endcontent-ref %}

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