Functions
This page contains reference documentation for functions in Apache Pinot.
This page contains reference documentation for functions in Apache Pinot.
pageABSpageADDpagearrayConcatDoublepagearrayConcatFloatpagearrayConcatIntpagearrayConcatLongpagearrayConcatStringpagearrayContainsIntpagearrayContainsStringpagearrayDistinctIntpagearrayDistinctStringpagearrayIndexOfIntpagearrayIndexOfStringpageARRAYLENGTHpagearrayRemoveIntpagearrayRemoveStringpagearrayReverseIntpagearrayReverseStringpagearraySliceIntpagearraySliceStringpagearraySortIntpagearraySortStringpagearrayUnionIntpagearrayUnionStringpageAVGMVpageBase64pagecaseWhenpageceilpageCHRpagecodepointpageconcatpagecountpageCOUNTMVpageDATETIMECONVERTpageDATETRUNCpagedaypagedayOfWeekpagedayOfYearpageDISTINCTpageDISTINCTCOUNTpageDISTINCTCOUNTBITMAPpageDISTINCTCOUNTHLLMVpageDISTINCTCOUNTHLLpageDISTINCTCOUNTBITMAPMVpageDISTINCTCOUNTMVpageDISTINCTCOUNTRAWHLLpageDISTINCTCOUNTRAWHLLMVpageDISTINCTCOUNTRAWTHETASKETCHpageDISTINCTCOUNTTHETASKETCHpageDIVpageexppageExtractpageFromDateTimepageFLOORpageFromEpochpageFromEpochBucketpageHistogrampagehourpagejsonextractkeypagejsonextractscalarpageJSONFORMATpageJSONPATHpageJSONPATHARRAYpageJSONPATHARRAYDEFAULTEMPTYpageJSONPATHDOUBLEpageJSONPATHLONGpageJSONPATHSTRINGpagelengthpagelnpagelowerpagelpadpageltrimpagemaxpageMAXMVpageMD5pagemillisecondpageminpageminmaxrangepageMINMAXRANGEMVpageMINMVpageminutepageMODpagemodepagemonthpagemultpagenowpagepercentilepagepercentileestpagepercentileestmvpagepercentiletdigestpagepercentiletdigestmvpagepercentilemvpagepercentilekllpagepercentilerawkllpagepercentilekllmvpagepercentilerawkllmvpagequarterpageregexpExtractpageremovepagereplacepagereversepageround