Functions

This page contains reference documentation for functions in Apache Pinot.

This page contains reference documentation for functions in Apache Pinot.

pageABSpageADDpagearrayConcatDoublepagearrayConcatFloatpagearrayConcatIntpagearrayConcatLongpagearrayConcatStringpagearrayContainsIntpagearrayContainsStringpagearrayDistinctIntpagearrayDistinctStringpagearrayIndexOfIntpagearrayIndexOfStringpageARRAYLENGTHpagearrayRemoveIntpagearrayRemoveStringpagearrayReverseIntpagearrayReverseStringpagearraySliceIntpagearraySliceStringpagearraySortIntpagearraySortStringpagearrayUnionIntpagearrayUnionStringpageAVGMVurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/avgvalueintegersumtuplesketch.mdpageBase64pagecaseWhenpageceilpageCHRurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/clpdecode.mdpagecodepointpageconcatpagecountpageCOUNTMVpageDATETIMECONVERTpageDATETRUNCpagedaypagedayOfWeekpagedayOfYearpageDISTINCTpageDISTINCTCOUNTpageDISTINCTCOUNTBITMAPpageDISTINCTCOUNTHLLMVpageDISTINCTCOUNTHLLpageDISTINCTCOUNTBITMAPMVpageDISTINCTCOUNTMVpageDISTINCTCOUNTRAWHLLpageDISTINCTCOUNTRAWHLLMVurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawcpcsketch.mdpageDISTINCTCOUNTRAWTHETASKETCHurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawintegersumtuplesketch.mdurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawull.mdurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountcpcsketch.mdpageDISTINCTCOUNTTHETASKETCHurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcounttuplesketch.mdurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountull.mdpageDIVpageexppageExtractpageFIRSTWITHTIMEurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/freqeuentlongssketch.mdurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/frequentstringsketch.mdpageFromDateTimepageFLOORpageFromEpochpageFromEpochBucketpageHistogrampagehourpagejsonextractkeypagejsonextractscalarpageJSONFORMATpageJSONPATHpageJSONPATHARRAYpageJSONPATHARRAYDEFAULTEMPTYpageJSONPATHDOUBLEpageJSONPATHLONGpageJSONPATHSTRINGpageLASTWITHTIMEpagelengthpagelnpagelowerpagelpadpageltrimpagemaxpageMAXMVpageMD5pagemillisecondpageminpageminmaxrangepageMINMAXRANGEMVpageMINMVpageminutepageMODpagemodepagemonthpagemultpagenowpagepercentilepagepercentileestpagepercentileestmvpagepercentiletdigestpagepercentiletdigestmvpagepercentilemvpagepercentilekllpagepercentilerawkllpagepercentilekllmvpagepercentilerawkllmvpagequarterpageregexpExtractpageremovepagereplacepagereversepageroundpageROW_NUMBERpagerpadpagertrimpagesecondpageSEGMENTPARTITIONEDDISTINCTCOUNTpageshapagesha256pagesha512pagesqrtpagestartswithpageST_AsBinarypageST_AsTextpageST_ContainspageST_DistancepageST_GeogFromTextpageST_GeogFromWKBpageST_GeometryTypepageST_GeomFromTextpageST_GeomFromWKBpageSTPOINTpageST_PolygonpagestrpospageST_UnionpageSUBpagesubstrpagesumurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/sumvaluesintegersumtuplesketch.mdpageTIMECONVERTurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/timezoneHour.mdurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/timezoneMinute.mdpageToDateTimeurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/toEpoch.mdurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/toEpochBucket.mdurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/toEpochRounded.mdpageTOJSONMAPSTRpagetoSphericalGeographypagetrimpageupperpageUrlpageUTF8pageVALUEINpageweekpageyearurlhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/yearOfWeek.md

Last updated