# Functions - [Overview](https://docs.pinot.apache.org/functions/functions.md): Browse Pinot function families and jump to the right execution-engine guidance. - [Transformations](https://docs.pinot.apache.org/functions/transformations.md): A curated guide to Pinot transformation functions used in queries and ingestion configs. - [Function Index](https://docs.pinot.apache.org/functions/function-index.md) - [Aggregation Functions](https://docs.pinot.apache.org/functions/aggregation.md): Aggregate functions return a single result for a group of rows. - [count](https://docs.pinot.apache.org/functions/aggregation/count.md): This section contains reference documentation for the count function. - [sum](https://docs.pinot.apache.org/functions/aggregation/sum.md): This section contains reference documentation for the sum function. - [summv](https://docs.pinot.apache.org/functions/aggregation/summv.md): This section contains reference documentation for the SUMMV function. - [min](https://docs.pinot.apache.org/functions/aggregation/min.md): This section contains reference documentation for the min function. - [MINMV](https://docs.pinot.apache.org/functions/aggregation/minmv.md): This section contains reference documentation for the MINMV function. - [max](https://docs.pinot.apache.org/functions/aggregation/max.md): This section contains reference documentation for the max function. - [MAXMV](https://docs.pinot.apache.org/functions/aggregation/maxmv.md): This section contains reference documentation for the MAXMV function. - [AVG](https://docs.pinot.apache.org/functions/aggregation/avg.md): This section contains reference documentation for the AVG function. - [AVGMV](https://docs.pinot.apache.org/functions/aggregation/avgmv.md): This section contains reference documentation for the AVGMV function. - [mode](https://docs.pinot.apache.org/functions/aggregation/mode.md): This section contains reference documentation for the mode function. - [Histogram](https://docs.pinot.apache.org/functions/aggregation/histogram.md): This section contains reference documentation for the HISTOGRAM function. - [SUMPRECISION](https://docs.pinot.apache.org/functions/aggregation/sumprecision.md): This section contains reference documentation for the SUMPRECISION function. - [ANYVALUE](https://docs.pinot.apache.org/functions/aggregation/anyvalue.md): This section contains reference documentation for the ANYVALUE function. - [BOOLAND](https://docs.pinot.apache.org/functions/aggregation/booland.md): This section contains reference documentation for the BOOLAND function. - [BOOLOR](https://docs.pinot.apache.org/functions/aggregation/boolor.md): This section contains reference documentation for the BOOLOR function. - [ARRAYAGG](https://docs.pinot.apache.org/functions/aggregation/arrayagg.md): This section contains reference documentation for the ARRAYAGG function. - [LISTAGG](https://docs.pinot.apache.org/functions/aggregation/listagg.md): This section contains reference documentation for the LISTAGG function. - [SUMARRAYLONG](https://docs.pinot.apache.org/functions/aggregation/sumarraylong.md): This section contains reference documentation for the SUMARRAYLONG function. - [SUMARRAYDOUBLE](https://docs.pinot.apache.org/functions/aggregation/sumarraydouble.md): This section contains reference documentation for the SUMARRAYDOUBLE function. - [SKEWNESS](https://docs.pinot.apache.org/functions/aggregation/skewness.md): This section contains reference documentation for the SKEWNESS function. - [KURTOSIS](https://docs.pinot.apache.org/functions/aggregation/kurtosis.md): This section contains reference documentation for the KURTOSIS function. - [DISTINCTSUM](https://docs.pinot.apache.org/functions/aggregation/distinctsum.md): This section contains reference documentation for the DISTINCTSUM function. - [DISTINCTAVG](https://docs.pinot.apache.org/functions/aggregation/distinctavg.md): This section contains reference documentation for the DISTINCTAVG function. - [EXPRMIN](https://docs.pinot.apache.org/functions/aggregation/exprmin.md): This section contains reference documentation for the EXPRMIN function. - [EXPRMAX](https://docs.pinot.apache.org/functions/aggregation/exprmax.md): This section contains reference documentation for the EXPRMAX function. - [EXPR\_MIN / EXPR\_MAX](https://docs.pinot.apache.org/functions/aggregation/arg_min-arg_max.md): This section contains reference documentation for the EXPR\_MIN and EXPR\_MAX function. - [IDSET](https://docs.pinot.apache.org/functions/aggregation/idset.md): This section contains reference documentation for the IDSET function. - [DISTINCT](https://docs.pinot.apache.org/functions/aggregation/distinct.md): This section contains reference documentation for the DISTINCT function. - [DISTINCTCOUNT](https://docs.pinot.apache.org/functions/aggregation/distinctcount.md): This section contains reference documentation for the DISTINCTCOUNT function. - [DISTINCTCOUNTBITMAP](https://docs.pinot.apache.org/functions/aggregation/distinctcountbitmap.md): This section contains reference documentation for the DISTINCTCOUNTBITMAP function. - [DISTINCTCOUNTHLL](https://docs.pinot.apache.org/functions/aggregation/distinctcounthll.md): This section contains reference documentation for the DISTINCTCOUNTHLL function. - [DISTINCTCOUNTTHETASKETCH](https://docs.pinot.apache.org/functions/aggregation/distinctcountthetasketch.md): This section contains reference documentation for the DISTINCTCOUNTTHETASKETCH function. - [DISTINCTCOUNTSMARTHLL](https://docs.pinot.apache.org/functions/aggregation/distinctcountsmarthll.md): This section contains reference documentation for the DISTINCT\_COUNT\_SMART\_HLL function. - [percentile](https://docs.pinot.apache.org/functions/aggregation/percentile.md): This section contains reference documentation for the percentile function. - [percentileest](https://docs.pinot.apache.org/functions/aggregation/percentileest.md): This section contains reference documentation for the percentileest function. - [percentilekll](https://docs.pinot.apache.org/functions/aggregation/percentilekll.md): This section contains reference documentation for the PERCENTILEKLL function. - [percentiletdigest](https://docs.pinot.apache.org/functions/aggregation/percentiletdigest.md): This section contains reference documentation for the PERCENTILETDIGEST function. - [FIRST\_VALUE](https://docs.pinot.apache.org/functions/aggregation/first_value.md): This section contains reference documentation for the FIRST\_VALUE window function. - [LAST\_VALUE](https://docs.pinot.apache.org/functions/aggregation/last_value.md): This section contains reference documentation for the LAST\_VALUE window function. - [LEAD](https://docs.pinot.apache.org/functions/aggregation/lead.md): This section contains reference documentation for the LEAD function. - [LAG](https://docs.pinot.apache.org/functions/aggregation/lag.md): This section contains reference documentation for the LAG function. - [FIRSTWITHTIME](https://docs.pinot.apache.org/functions/aggregation/firstwithtime.md): This section contains reference documentation for the firstwithtime function. - [LASTWITHTIME](https://docs.pinot.apache.org/functions/aggregation/lastwithtime.md): This section contains reference documentation for the lastwithtime function. - [COUNTMV](https://docs.pinot.apache.org/functions/aggregation/countmv.md): This section contains reference documentation for the COUNTMV function. - [MINMAXRANGEMV](https://docs.pinot.apache.org/functions/aggregation/minmaxrangemv.md): This section contains reference documentation for the MINMAXRANGEMV function. - [percentilemv](https://docs.pinot.apache.org/functions/aggregation/percentilemv.md): This section contains reference documentation for the PERCENTILEMV function. - [percentileestmv](https://docs.pinot.apache.org/functions/aggregation/percentileestmv.md): This section contains reference documentation for the PERCENTILEESTMV function. - [percentiletdigestmv](https://docs.pinot.apache.org/functions/aggregation/percentiletdigestmv.md): This section contains reference documentation for the PERCENTILETDIGESTMV function. - [DISTINCTCOUNTMV](https://docs.pinot.apache.org/functions/aggregation/distinctcountmv.md): This section contains reference documentation for the DISTINCTCOUNTMV function. - [DISTINCTCOUNTBITMAPMV](https://docs.pinot.apache.org/functions/aggregation/distinctcountbitmapmv.md): This section contains reference documentation for the DISTINCTCOUNTBITMAPMV function. - [DISTINCTCOUNTHLLMV](https://docs.pinot.apache.org/functions/aggregation/distinctcounthllmv.md): This section contains reference documentation for the DISTINCTCOUNTHLLMV function. - [DISTINCTCOUNTRAWHLLMV](https://docs.pinot.apache.org/functions/aggregation/distinctcountrawhllmv.md): This section contains reference documentation for the DISTINCTCOUNTRAWHLLMV function. - [DISTINCTSUMMV](https://docs.pinot.apache.org/functions/aggregation/distinctsummv.md): This section contains reference documentation for the DISTINCTSUMMV function. - [DISTINCTAVGMV](https://docs.pinot.apache.org/functions/aggregation/distinctavgmv.md): This section contains reference documentation for the DISTINCTAVGMV function. - [DISTINCT\_COUNT\_OFF\_HEAP](https://docs.pinot.apache.org/functions/aggregation/distinct_count_off_heap.md): This section contains reference documentation for the DISTINCT\_COUNT\_OFF\_HEAP function. - [DISTINCTCOUNTHLLPLUS](https://docs.pinot.apache.org/functions/aggregation/distinctcounthll-1.md): This section contains reference documentation for the DISTINCTCOUNTHLLPLUS function. - [DISTINCTCOUNTRAWHLL](https://docs.pinot.apache.org/functions/aggregation/distinctcountrawhll.md): This section contains reference documentation for the DISTINCTCOUNTRAWHLL function. - [DISTINCTCOUNTRAWTHETASKETCH](https://docs.pinot.apache.org/functions/aggregation/distinctcountrawthetasketch.md): This section contains reference documentation for the DISTINCTCOUNTRAWTHETASKETCH function. - [DISTINCTCOUNTULL](https://docs.pinot.apache.org/functions/aggregation/distinctcountull.md) - [FUNNELEVENTSFUNCTIONEVAL](https://docs.pinot.apache.org/functions/aggregation/funneleventsfunctioneval.md): This section contains reference documentation for the FUNNELEVENTSFUNCTIONEVAL function. - [FUNNELSTEPDURATIONSTATS](https://docs.pinot.apache.org/functions/aggregation/funnelstepdurationstats.md): This section contains reference documentation for the FUNNELSTEPDURATIONSTATS function. - [maxString](https://docs.pinot.apache.org/functions/aggregation/maxstring.md): This section contains reference documentation for the maxString function. - [minmaxrange](https://docs.pinot.apache.org/functions/aggregation/minmaxrange.md): This section contains reference documentation for the minmaxrange function. - [minString](https://docs.pinot.apache.org/functions/aggregation/minstring.md): This section contains reference documentation for the minString function. - [percentilekllmv](https://docs.pinot.apache.org/functions/aggregation/percentilekllmv.md): This section contains reference documentation for the PERCENTILEKLLMV function. - [percentilerawkll](https://docs.pinot.apache.org/functions/aggregation/percentilerawkll.md): This section contains reference documentation for the PERCENTILERAWKLL function. - [percentilerawkllmv](https://docs.pinot.apache.org/functions/aggregation/percentilerawkllmv.md): This section contains reference documentation for the PERCENTILERAWKLLMV function. - [SEGMENTPARTITIONEDDISTINCTCOUNT](https://docs.pinot.apache.org/functions/aggregation/segmentpartitioneddistinctcount.md): This section contains reference documentation for the SEGMENTPARTITIONEDDISTINCTCOUNT function. - [VALUEIN](https://docs.pinot.apache.org/functions/aggregation/valuein.md): This section contains reference documentation for the VALUEIN function. - [Array Functions](https://docs.pinot.apache.org/functions/array.md) - [filterMv](https://docs.pinot.apache.org/functions/array/filtermv.md): This section contains reference documentation for the filterMv function. - [ARRAY\_AGG](https://docs.pinot.apache.org/functions/array/array_agg.md): This section contains reference documentation for the ARRAY\_AGG function. - [arrayConcatDouble](https://docs.pinot.apache.org/functions/array/arrayconcatdouble.md): This section contains reference documentation for the arrayConcatDouble function. - [arrayConcatFloat](https://docs.pinot.apache.org/functions/array/arrayconcatfloat.md): This section contains reference documentation for the arrayConcatFloat function. - [arrayConcatInt](https://docs.pinot.apache.org/functions/array/arrayconcatint.md): This section contains reference documentation for the arrayConcatInt function. - [arrayConcatLong](https://docs.pinot.apache.org/functions/array/arrayconcatlong.md): This section contains reference documentation for the arrayConcatLong function. - [arrayConcatString](https://docs.pinot.apache.org/functions/array/arrayconcatstring.md): This section contains reference documentation for the arrayConcatString function. - [arrayContainsInt](https://docs.pinot.apache.org/functions/array/arraycontainsint.md): This section contains reference documentation for the arrayContainsInt function. - [arrayContainsString](https://docs.pinot.apache.org/functions/array/arraycontainsstring.md): This section contains reference documentation for the arrayContainsString function. - [arrayDistinctInt](https://docs.pinot.apache.org/functions/array/arraydistinctint.md): This section contains reference documentation for the arrayDistinctInt function. - [arrayDistinctString](https://docs.pinot.apache.org/functions/array/arraydistinctstring.md): This section contains reference documentation for the arrayDistinctString function. - [arrayIndexOfInt](https://docs.pinot.apache.org/functions/array/arrayindexofint.md): This section contains reference documentation for the arrayIndexOfInt function. - [arrayIndexOfString](https://docs.pinot.apache.org/functions/array/arrayindexofstring.md): This section contains reference documentation for the arrayIndexOfString function. - [ARRAYLENGTH](https://docs.pinot.apache.org/functions/array/arraylength.md): This section contains reference documentation for the ARRAYLENGTH function. - [arrayPushBack](https://docs.pinot.apache.org/functions/array/arraypushback.md): This section contains reference documentation for the arrayPushBack functions. - [arrayPushFront](https://docs.pinot.apache.org/functions/array/arraypushfront.md): This section contains reference documentation for the arrayPushFront functions. - [arrayRemoveInt](https://docs.pinot.apache.org/functions/array/arrayremoveint.md): This section contains reference documentation for the arrayRemoveInt function. - [arrayRemoveString](https://docs.pinot.apache.org/functions/array/arrayremovestring.md): This section contains reference documentation for the arrayRemoveString function. - [arrayReverseInt](https://docs.pinot.apache.org/functions/array/arrayreverseint.md): This section contains reference documentation for the arrayReverseInt function. - [arrayReverseString](https://docs.pinot.apache.org/functions/array/arrayreversestring.md): This section contains reference documentation for the arrayReverseString function. - [arraySliceInt](https://docs.pinot.apache.org/functions/array/arraysliceint.md): This section contains reference documentation for the arraySliceInt function. - [arraySliceString](https://docs.pinot.apache.org/functions/array/arrayslicestring.md): This section contains reference documentation for the arraySliceString function. - [arraySortInt](https://docs.pinot.apache.org/functions/array/arraysortint.md): This section contains reference documentation for the arraySortInt function. - [arraySortString](https://docs.pinot.apache.org/functions/array/arraysortstring.md): This section contains reference documentation for the arraySortString function. - [arraysOverlap](https://docs.pinot.apache.org/functions/array/arraysoverlap.md): This section contains reference documentation for the arraysOverlap function. - [arrayToString](https://docs.pinot.apache.org/functions/array/arraytostring.md): This section contains reference documentation for the arrayToString function. - [arrayUnionInt](https://docs.pinot.apache.org/functions/array/arrayunionint.md): This section contains reference documentation for the arrayUnionInt function. - [arrayUnionString](https://docs.pinot.apache.org/functions/array/arrayunionstring.md): This section contains reference documentation for the arrayUnionString function. - [isEqualSet](https://docs.pinot.apache.org/functions/array/isequalset.md): This section contains reference documentation for the isEqualSet function. - [Binary Functions](https://docs.pinot.apache.org/functions/binary.md) - [sha](https://docs.pinot.apache.org/functions/binary/sha.md): This section contains reference documentation for the SHA function. - [sha256](https://docs.pinot.apache.org/functions/binary/sha256.md): This section contains reference documentation for the SHA256 function. - [sha512](https://docs.pinot.apache.org/functions/binary/sha512.md): This section contains reference documentation for the SHA512 function. - [MD5](https://docs.pinot.apache.org/functions/binary/md5.md): This section contains reference documentation for the MD5 function. - [Base64](https://docs.pinot.apache.org/functions/binary/base64.md): This section contains reference documentation for base64 encode and decode functions. - [UTF8](https://docs.pinot.apache.org/functions/binary/utf8.md): This section contains reference documentation for UTF8 encode/decode functions. - [CLP Functions](https://docs.pinot.apache.org/functions/clp.md): Reference documentation for CLP (Compressed Log Processor) functions in Apache Pinot. - [CLPDECODE](https://docs.pinot.apache.org/functions/clp/clpdecode.md): This section contains reference documentation for the CLPDECODE function. - [DateTime Functions](https://docs.pinot.apache.org/functions/datetime.md) - [ago](https://docs.pinot.apache.org/functions/datetime/ago.md): This section contains reference documentation for the ago function. - [DATETIMECONVERT](https://docs.pinot.apache.org/functions/datetime/datetimeconvert.md): This section contains reference documentation for the DATETIMECONVERT function. - [DATETRUNC](https://docs.pinot.apache.org/functions/datetime/datetrunc.md): This section contains reference documentation for the DATETRUNC function. - [day](https://docs.pinot.apache.org/functions/datetime/day.md): This section contains reference documentation for the day function. - [dayOfWeek](https://docs.pinot.apache.org/functions/datetime/dayofweek.md): This section contains reference documentation for the dayOfWeek function. - [dayOfYear](https://docs.pinot.apache.org/functions/datetime/dayofyear.md): This section contains reference documentation for the dayOfYear function. - [Extract](https://docs.pinot.apache.org/functions/datetime/extract.md): This section contains reference documentation for the Extract function. - [FromDateTime](https://docs.pinot.apache.org/functions/datetime/fromdatetime.md): This section contains reference documentation for the FromDateTime function. - [FromEpoch](https://docs.pinot.apache.org/functions/datetime/fromepoch.md): This section contains reference documentation for the fromEpoch functions. - [FromEpochBucket](https://docs.pinot.apache.org/functions/datetime/fromepochbucket.md): This section contains reference documentation for the fromEpochBucket functions. - [hour](https://docs.pinot.apache.org/functions/datetime/hour.md): This section contains reference documentation for the hour function. - [millisecond](https://docs.pinot.apache.org/functions/datetime/millisecond.md): This section contains reference documentation for the millisecond function. - [minute](https://docs.pinot.apache.org/functions/datetime/minute.md): This section contains reference documentation for the minute function. - [month](https://docs.pinot.apache.org/functions/datetime/month.md): This section contains reference documentation for the month function. - [now](https://docs.pinot.apache.org/functions/datetime/now.md): This section contains reference documentation for the now function. - [quarter](https://docs.pinot.apache.org/functions/datetime/quarter.md): This section contains reference documentation for the quarter function. - [second](https://docs.pinot.apache.org/functions/datetime/second.md): This section contains reference documentation for the second function. - [TIMECONVERT](https://docs.pinot.apache.org/functions/datetime/timeconvert.md): This section contains reference documentation for the TIMECONVERT function. - [timezoneHour](https://docs.pinot.apache.org/functions/datetime/timezonehour.md): This section contains reference documentation for the timezoneHour function. - [timezoneMinute](https://docs.pinot.apache.org/functions/datetime/timezoneminute.md): This section contains reference documentation for the timezoneMinute function. - [ToDateTime](https://docs.pinot.apache.org/functions/datetime/todatetime.md): This section contains reference documentation for the ToDateTime function. - [ToEpoch](https://docs.pinot.apache.org/functions/datetime/toepoch.md): This section contains reference documentation for the toEpoch functions. - [ToEpochBucket](https://docs.pinot.apache.org/functions/datetime/toepochbucket.md): This section contains reference documentation for the toEpochBucket functions. - [ToEpochRounded](https://docs.pinot.apache.org/functions/datetime/toepochrounded.md): This section contains reference documentation for the toEpochRounded functions. - [week](https://docs.pinot.apache.org/functions/datetime/week.md): This section contains reference documentation for the week function. - [year](https://docs.pinot.apache.org/functions/datetime/year.md): This section contains reference documentation for the year function. - [yearOfWeek](https://docs.pinot.apache.org/functions/datetime/yearofweek.md): This section contains reference documentation for the yearOfWeek function. - [Funnel Analysis Functions](https://docs.pinot.apache.org/functions/funnel.md) - [FunnelMaxStep](https://docs.pinot.apache.org/functions/funnel/funnelmaxstep-1.md) - [FunnelMatchStep](https://docs.pinot.apache.org/functions/funnel/funnelmaxstep-2.md) - [FUNNELCOMPLETECOUNT](https://docs.pinot.apache.org/functions/funnel/funnelcompletecount.md): This section contains reference documentation for the FUNNELCOMPLETECOUNT function. - [FUNNELCOUNT](https://docs.pinot.apache.org/functions/funnel/funnelcount.md): This section contains reference documentation for the FUNNELCOUNT function. - [FunnelCompleteCount](https://docs.pinot.apache.org/functions/funnel/funnelmaxstep.md) - [GeoSpatial Functions](https://docs.pinot.apache.org/functions/geospatial.md) - [ST\_GeomFromText](https://docs.pinot.apache.org/functions/geospatial/stgeomfromtext.md): This section contains reference documentation for the ST\_GeomFromText function. - [ST\_GeomFromWKB](https://docs.pinot.apache.org/functions/geospatial/stgeomfromwkb.md): This section contains reference documentation for the ST\_GeomFromWKB function. - [STPOINT](https://docs.pinot.apache.org/functions/geospatial/stpoint.md): This section contains reference documentation for the ST\_POINT/STPOINT function. - [ST\_Polygon](https://docs.pinot.apache.org/functions/geospatial/stpolygon.md): This section contains reference documentation for the ST\_Polygon function. - [ST\_GeogFromWKB](https://docs.pinot.apache.org/functions/geospatial/stgeogfromwkb.md): This section contains reference documentation for the ST\_GeogFromWKB function. - [ST\_GeogFromText](https://docs.pinot.apache.org/functions/geospatial/stgeogfromtext.md): This section contains reference documentation for the ST\_GeogFromText function. - [ST\_Distance](https://docs.pinot.apache.org/functions/geospatial/stdistance.md): This section contains reference documentation for the ST\_Distance function. - [ST\_GeometryType](https://docs.pinot.apache.org/functions/geospatial/stgeometrytype.md): This section contains reference documentation for the ST\_GeometryType function. - [ST\_AsBinary](https://docs.pinot.apache.org/functions/geospatial/stasbinary.md): This section contains reference documentation for the ST\_AsBinary function. - [ST\_AsText](https://docs.pinot.apache.org/functions/geospatial/stastext.md): This section contains reference documentation for the ST\_AsText function. - [toSphericalGeography](https://docs.pinot.apache.org/functions/geospatial/tosphericalgeography.md): This section contains reference documentation for the toSphericalGeography function. - [toGeometry](https://docs.pinot.apache.org/functions/geospatial/togeometry.md): This section contains reference documentation for the toGeometry function. - [ST\_Contains](https://docs.pinot.apache.org/functions/geospatial/stcontains.md): This section contains reference documentation for the ST\_Contains function. - [ST\_Union](https://docs.pinot.apache.org/functions/geospatial/stunion.md): This section contains reference documentation for the ST\_Union function. - [GridDistance](https://docs.pinot.apache.org/functions/geospatial/griddistance.md): This section contains reference documentation for the gridDistance function. - [GridDisk](https://docs.pinot.apache.org/functions/geospatial/griddisk.md): This section contains reference documentation for the gridDisk function. - [ST\_AsGeoJSON](https://docs.pinot.apache.org/functions/geospatial/st_asgeojson.md): This section contains reference documentation for the ST\_AsGeoJSON function. - [ST\_GeogFromGeoJSON](https://docs.pinot.apache.org/functions/geospatial/st_geogfromgeojson.md): This section contains reference documentation for the ST\_GeogFromGeoJSON function. - [ST\_GeomFromGeoJSON](https://docs.pinot.apache.org/functions/geospatial/st_geomfromgeojson.md): This section contains reference documentation for the ST\_GeomFromGeoJSON function. - [Hash Functions](https://docs.pinot.apache.org/functions/hash.md) - [IP Address Functions](https://docs.pinot.apache.org/functions/ip-address.md) - [JSON Functions](https://docs.pinot.apache.org/functions/json.md) - [jsonextractscalar](https://docs.pinot.apache.org/functions/json/jsonextractscalar.md): This section contains reference documentation for the JSONEXTRACTSCALAR function. - [jsonextractkey](https://docs.pinot.apache.org/functions/json/jsonextractkey.md): This section contains reference documentation for the JSONEXTRACTKEY function. - [jsonextractindex](https://docs.pinot.apache.org/functions/json/jsonextractindex.md): This section contains reference documentation for the JSONEXTRACTINDEX function. - [TOJSONMAPSTR](https://docs.pinot.apache.org/functions/json/tojsonmapstr.md): This section contains reference documentation for the TOJSONMAPSTR function. - [JSONFORMAT](https://docs.pinot.apache.org/functions/json/jsonformat.md): This section contains reference documentation for the JSONFORMAT function. - [JSONPATH](https://docs.pinot.apache.org/functions/json/jsonpath.md): This section contains reference documentation for the JSONPATH function. - [JSONPATHARRAY](https://docs.pinot.apache.org/functions/json/jsonpatharray.md): This section contains reference documentation for the JSONPATHARRAY function. - [JSONPATHARRAYDEFAULTEMPTY](https://docs.pinot.apache.org/functions/json/jsonpatharraydefaultempty.md): This section contains reference documentation for the JSONPATHARRAYDEFAULTEMPTY function. - [JSONPATHEXISTS](https://docs.pinot.apache.org/functions/json/jsonpathexists.md): This section contains reference documentation for the JSONPATHEXISTS function. - [JSONKEYVALUEARRAYTOMAP](https://docs.pinot.apache.org/functions/json/jsonkeyvaluearraytomap.md): This section contains reference documentation for the JSONKEYVALUEARRAYTOMAP function. - [JSONPATHLONG](https://docs.pinot.apache.org/functions/json/jsonpathlong.md): This section contains reference documentation for the JSONPATHLONG function. - [JSONPATHDOUBLE](https://docs.pinot.apache.org/functions/json/jsonpathdouble.md): This section contains reference documentation for the JSONPATHDOUBLE function. - [JSONPATHSTRING](https://docs.pinot.apache.org/functions/json/jsonpathstring.md): This section contains reference documentation for the JSONPATHSTRING function. - [Math Functions](https://docs.pinot.apache.org/functions/math.md) - [ADD](https://docs.pinot.apache.org/functions/math/add.md): This section contains reference documentation for the ADD function. - [SUB](https://docs.pinot.apache.org/functions/math/sub.md): This section contains reference documentation for the SUB function. - [mult](https://docs.pinot.apache.org/functions/math/mult.md): This section contains reference documentation for the MULT function. - [DIV](https://docs.pinot.apache.org/functions/math/div.md): This section contains reference documentation for the DIV function. - [MOD](https://docs.pinot.apache.org/functions/math/mod.md): This section contains reference documentation for the MOD function. - [ABS](https://docs.pinot.apache.org/functions/math/abs.md): This section contains reference documentation for the abs function. - [ceil](https://docs.pinot.apache.org/functions/math/ceil.md): This section contains reference documentation for the CEIL function. - [FLOOR](https://docs.pinot.apache.org/functions/math/floor.md): This section contains reference documentation for the FLOOR function. - [exp](https://docs.pinot.apache.org/functions/math/exp.md): This section contains reference documentation for the exp function. - [ln](https://docs.pinot.apache.org/functions/math/ln.md): This section contains reference documentation for the ln function. - [sqrt](https://docs.pinot.apache.org/functions/math/sqrt.md): This section contains reference documentation for the sqrt function. - [roundDecimal](https://docs.pinot.apache.org/functions/math/round-1.md) - [round](https://docs.pinot.apache.org/functions/math/round.md): This section contains reference documentation for the round function. - [intDiv](https://docs.pinot.apache.org/functions/math/intdiv.md): This section contains reference documentation for the intDiv function. - [intDivOrZero](https://docs.pinot.apache.org/functions/math/intdivorzero.md): This section contains reference documentation for the intDivOrZero function. - [isFinite](https://docs.pinot.apache.org/functions/math/isfinite.md): This section contains reference documentation for the isFinite function. - [isInfinite](https://docs.pinot.apache.org/functions/math/isinfinite.md): This section contains reference documentation for the isInfinite function. - [ifNotFinite](https://docs.pinot.apache.org/functions/math/ifnotfinite.md): This section contains reference documentation for the ifNotFinite function. - [isNaN](https://docs.pinot.apache.org/functions/math/isnan.md): This section contains reference documentation for the isNaN function. - [moduloOrZero](https://docs.pinot.apache.org/functions/math/moduloorzero.md): This section contains reference documentation for the moduloOrZero function. - [positiveModulo](https://docs.pinot.apache.org/functions/math/positivemodulo.md): This section contains reference documentation for the positiveModulo function. - [negate](https://docs.pinot.apache.org/functions/math/negate.md): This section contains reference documentation for the negate function. - [greatest](https://docs.pinot.apache.org/functions/math/greatest.md): This section contains reference documentation for the greatest function. - [least](https://docs.pinot.apache.org/functions/math/least.md): This section contains reference documentation for the least function. - [gcd](https://docs.pinot.apache.org/functions/math/gcd.md): This section contains reference documentation for the gcd function. - [lcm](https://docs.pinot.apache.org/functions/math/lcm.md): This section contains reference documentation for the lcm function. - [hypot](https://docs.pinot.apache.org/functions/math/hypot.md): This section contains reference documentation for the hypot function. - [byteswapInt](https://docs.pinot.apache.org/functions/math/byteswapint.md): This section contains reference documentation for the byteswapInt function. - [byteswapLong](https://docs.pinot.apache.org/functions/math/byteswaplong.md): This section contains reference documentation for the byteswapLong function. - [Bitwise Functions](https://docs.pinot.apache.org/functions/math/bitwise.md): This section contains reference documentation for bitwise scalar functions. - [Miscellaneous Functions](https://docs.pinot.apache.org/functions/misc.md): Reference documentation for miscellaneous functions in Apache Pinot. - [caseWhen](https://docs.pinot.apache.org/functions/misc/casewhen.md): This section contains reference documentation for the caseWhen function. - [isSubnetOf](https://docs.pinot.apache.org/functions/misc/issubnetof.md): This section contains reference documentation for the isSubnetOf function. - [Null Handling Functions](https://docs.pinot.apache.org/functions/null-handling.md) - [Sketch Functions](https://docs.pinot.apache.org/functions/sketch.md): Reference documentation for approximate distinct count and sketch-based aggregation functions in Apache Pinot. - [DISTINCTCOUNTCPCSKETCH](https://docs.pinot.apache.org/functions/sketch/distinctcountcpcsketch.md): This section contains reference documentation for the DISTINCTCOUNTCPCSKETCH function. - [DISTINCTCOUNTRAWCPCSKETCH](https://docs.pinot.apache.org/functions/sketch/distinctcountrawcpcsketch.md): This section contains reference documentation for the DISTINCTCOUNTRAWCPCSKETCH function. - [DISTINCTCOUNTHLLPLUS](https://docs.pinot.apache.org/functions/sketch/distinctcounthllplus.md): This section contains reference documentation for the DISTINCTCOUNTHLLPLUS function. - [DISTINCTCOUNTHLLPLUSMV](https://docs.pinot.apache.org/functions/sketch/distinctcounthllplusmv.md): This section contains reference documentation for the DISTINCTCOUNTHLLPLUSMV function. - [DISTINCTCOUNTRAWHLLPLUS](https://docs.pinot.apache.org/functions/sketch/distinctcountrawhllplus.md): This section contains reference documentation for the DISTINCTCOUNTRAWHLLPLUS function. - [DISTINCTCOUNTRAWHLLPLUSMV](https://docs.pinot.apache.org/functions/sketch/distinctcountrawhllplusmv.md): This section contains reference documentation for the DISTINCTCOUNTRAWHLLPLUSMV function. - [DISTINCTCOUNTULL](https://docs.pinot.apache.org/functions/sketch/distinctcountull.md): This section contains reference documentation for the DISTINCTCOUNTULL function. - [DISTINCTCOUNTRAWULL](https://docs.pinot.apache.org/functions/sketch/distinctcountrawull.md): This section contains reference documentation for the DISTINCTCOUNTRAWULL function. - [DISTINCTCOUNTTUPLESKETCH](https://docs.pinot.apache.org/functions/sketch/distinctcounttuplesketch.md): This section contains reference documentation for the DISTINCTCOUNTTUPLESKETCH function. - [DISTINCTCOUNTRAWINTEGERSUMTUPLESKETCH](https://docs.pinot.apache.org/functions/sketch/distinctcountrawintegersumtuplesketch.md): This section contains reference documentation for the DISTINCTCOUNTRAWINTEGERSUMTUPLESKETCH function. - [AVGVALUEINTEGERSUMTUPLESKETCH](https://docs.pinot.apache.org/functions/sketch/avgvalueintegersumtuplesketch.md): This section contains reference documentation for the AVGVALUEINTEGERSUMTUPLESKETCH function. - [SUMVALUESINTEGERSUMTUPLESKETCH](https://docs.pinot.apache.org/functions/sketch/sumvaluesintegersumtuplesketch.md): This section contains reference documentation for the SUMVALUESINTEGERSUMTUPLESKETCH function. - [FrequentLongsSketch](https://docs.pinot.apache.org/functions/sketch/frequentlongssketch.md): This section contains reference documentation for the FREQUENTLONGSSKETCH function. - [FrequentStringsSketch](https://docs.pinot.apache.org/functions/sketch/frequentstringssketch.md): This section contains reference documentation for the FREQUENTSTRINGSSKETCH function. - [Statistical Functions](https://docs.pinot.apache.org/functions/statistical.md) - [VARPOP](https://docs.pinot.apache.org/functions/statistical/varpop.md): This section contains reference documentation for the VARPOP function. - [VARSAMP](https://docs.pinot.apache.org/functions/statistical/varsamp.md): This section contains reference documentation for the VARSAMP function. - [STDDEVPOP](https://docs.pinot.apache.org/functions/statistical/stddevpop.md): This section contains reference documentation for the STDDEVPOP function. - [STDDEVSAMP](https://docs.pinot.apache.org/functions/statistical/stddevsamp.md): This section contains reference documentation for the STDDEVSAMP function. - [COVAR\_POP](https://docs.pinot.apache.org/functions/statistical/covar_pop.md): This section contains reference documentation for the COVAR\_POP function. - [COVAR\_SAMP](https://docs.pinot.apache.org/functions/statistical/covar_samp.md): This section contains reference documentation for the COVAR\_SAMP function. - [String Functions](https://docs.pinot.apache.org/functions/string.md) - [upper](https://docs.pinot.apache.org/functions/string/upper.md): This section contains reference documentation for the upper function. - [lower](https://docs.pinot.apache.org/functions/string/lower.md): This section contains reference documentation for the lower function. - [initcap](https://docs.pinot.apache.org/functions/string/initcap.md): This section contains reference documentation for the initcap function. - [reverse](https://docs.pinot.apache.org/functions/string/reverse.md): This section contains reference documentation for the reverse function. - [substr](https://docs.pinot.apache.org/functions/string/substr.md): This section contains reference documentation for the substr function. - [concat](https://docs.pinot.apache.org/functions/string/concat.md): This section contains reference documentation for the concat function. - [trim](https://docs.pinot.apache.org/functions/string/trim.md): This section contains reference documentation for the trim function. - [ltrim](https://docs.pinot.apache.org/functions/string/ltrim.md): This section contains reference documentation for the ltrim function. - [rtrim](https://docs.pinot.apache.org/functions/string/rtrim.md): This section contains reference documentation for the rtrim function. - [length](https://docs.pinot.apache.org/functions/string/length.md): This section contains reference documentation for the length function. - [levenshtein\_distance](https://docs.pinot.apache.org/functions/string/levenshtein_distance.md): This section contains reference documentation for the levenshtein\_distance function. - [soundex](https://docs.pinot.apache.org/functions/string/soundex.md): This section contains reference documentation for the soundex function. - [difference](https://docs.pinot.apache.org/functions/string/difference.md): This section contains reference documentation for the difference function. - [splitPart](https://docs.pinot.apache.org/functions/string/splitpart.md): This section contains reference documentation for the splitPart function. - [strpos](https://docs.pinot.apache.org/functions/string/strpos.md): This section contains reference documentation for the STRPOS function. - [startswith](https://docs.pinot.apache.org/functions/string/startswith.md): This section contains reference documentation for the STARTSWITH function. - [replace](https://docs.pinot.apache.org/functions/string/replace.md): This section contains reference documentation for the REPLACE function. - [rpad](https://docs.pinot.apache.org/functions/string/rpad.md): This section contains reference documentation for the RPAD function. - [lpad](https://docs.pinot.apache.org/functions/string/lpad.md): This section contains reference documentation for the LPAD function. - [codepoint](https://docs.pinot.apache.org/functions/string/codepoint.md): This section contains reference documentation for the CODEPOINT function. - [CHR](https://docs.pinot.apache.org/functions/string/chr.md): This section contains reference documentation for the CHR function. - [regexpExtract](https://docs.pinot.apache.org/functions/string/regexpextract.md): This section contains reference documentation for the regexpExtract function. - [regexpReplace](https://docs.pinot.apache.org/functions/string/regexpreplace.md): This section contains reference documentation for the regexpReplace function - [remove](https://docs.pinot.apache.org/functions/string/remove.md): This section contains reference documentation for the remove function. - [Url](https://docs.pinot.apache.org/functions/string/url.md): This section contains reference documentation for the url functions. - [Add Prefix, Suffix & Ngram UDFs](https://docs.pinot.apache.org/functions/string/add-prefix-suffix-ngram-udfs.md): This section contains reference documentation for the add prefix, suffix and ngram UDFs. - [Trigonometric Functions](https://docs.pinot.apache.org/functions/trigonometric.md) - [Type Conversion Functions](https://docs.pinot.apache.org/functions/type-conversion.md) - [URL Functions](https://docs.pinot.apache.org/functions/url.md) - [User-Defined Functions (UDFs)](https://docs.pinot.apache.org/functions/udf.md) - [Unique Count and Cardinality Estimation Functions](https://docs.pinot.apache.org/functions/unique-counting.md): Distinct count - [Vector / Similarity Functions](https://docs.pinot.apache.org/functions/vector.md) - [Window Functions](https://docs.pinot.apache.org/functions/window.md): Use window functions to compute averages, sort, rank, or count items, calculate sums, and find minimum or maximum values across windows. - [ROW\_NUMBER](https://docs.pinot.apache.org/functions/window/row_number.md): This section contains reference documentation for the ROW\_NUMBER window function. - [RANK](https://docs.pinot.apache.org/functions/window/rank.md): This section contains reference documentation for the RANK window function. - [DENSE\_RANK](https://docs.pinot.apache.org/functions/window/dense_rank.md): This section contains reference documentation for the DENSE\_RANK window function. --- # 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/functions.md?ask= ``` 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.