# Function List

{% hint style="danger" %}
Since the functions are too many and there is not point to make a full list here just for function name checking.

We decided to segregate functions into its usage and re-organize them.
{% endhint %}

This page contains reference documentation for functions in Apache Pinot.

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

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

{% content-ref url="functions-1/array\_agg" %}
[array\_agg](https://docs.pinot.apache.org/release-1.4.0/functions-1/array_agg)
{% endcontent-ref %}

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

{% content-ref url="functions-1/distinctcounthllmv" %}
[distinctcounthllmv](https://docs.pinot.apache.org/release-1.4.0/functions-1/distinctcounthllmv)
{% 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="functions-1/distinctcountmv" %}
[distinctcountmv](https://docs.pinot.apache.org/release-1.4.0/functions-1/distinctcountmv)
{% endcontent-ref %}

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

{% content-ref url="functions-1/st\_asgeojson" %}
[st\_asgeojson](https://docs.pinot.apache.org/release-1.4.0/functions-1/st_asgeojson)
{% endcontent-ref %}

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

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

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

{% content-ref url="functions-1/st\_geogfromgeojson" %}
[st\_geogfromgeojson](https://docs.pinot.apache.org/release-1.4.0/functions-1/st_geogfromgeojson)
{% endcontent-ref %}

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

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

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

{% content-ref url="functions-1/st\_geomfromgeojson" %}
[st\_geomfromgeojson](https://docs.pinot.apache.org/release-1.4.0/functions-1/st_geomfromgeojson)
{% endcontent-ref %}

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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