# Functions

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