Functions

This page contains reference documentation for functions in Apache Pinot.

This page contains reference documentation for functions in Apache Pinot.

pageABSpageADDpagearrayConcatDoublepagearrayConcatFloatpagearrayConcatIntpagearrayConcatLongpagearrayConcatStringpagearrayContainsIntpagearrayContainsStringpagearrayDistinctIntpagearrayDistinctStringpagearrayIndexOfIntpagearrayIndexOfStringpageARRAYLENGTHpagearrayRemoveIntpagearrayRemoveStringpagearrayReverseIntpagearrayReverseStringpagearraySliceIntpagearraySliceStringpagearraySortIntpagearraySortStringpagearrayUnionIntpagearrayUnionStringpageAVGMVpageBase64pageceilpageCHRpagecodepointpageconcatpagecountpageCOUNTMVpageDATETIMECONVERTpageDATETRUNCpagedaypagedayOfWeekpagedayOfYearpageDISTINCTpageDISTINCTCOUNTpageDISTINCTCOUNTBITMAPpageDISTINCTCOUNTBITMAPMVpageDISTINCTCOUNTHLLpageDISTINCTCOUNTHLLMVpageDISTINCTCOUNTMVpageDISTINCTCOUNTRAWHLLpageDISTINCTCOUNTRAWHLLMVpageDISTINCTCOUNTRAWTHETASKETCHpageDISTINCTCOUNTTHETASKETCHpageDIVpageexppageFromDateTimepageFLOORpageFromEpochpageFromEpochBucketpageHistogrampagehourpagejsonextractkeypagejsonextractscalarpageJSONFORMATpageJSONPATHpageJSONPATHARRAYpageJSONPATHARRAYDEFAULTEMPTYpageJSONPATHDOUBLEpageJSONPATHLONGpageJSONPATHSTRINGpagelengthpagelnpagelowerpagelpadpageltrimpagemaxpageMAXMVpageMD5pagemillisecondpageminpageminmaxrangepageMINMAXRANGEMVpageMINMVpageminutepageMODpagemodepagemonthpagemultpagenowpagepercentilepagepercentileestpagepercentileestmvpagepercentiletdigestpagepercentiletdigestmvpagepercentilemvpagequarterpageregexpExtractpageremovepagereplacepagereversepageroundpagerpadpagertrimpagesecondpageSEGMENTPARTITIONEDDISTINCTCOUNTpageshapagesha256pagesha512pagesqrtpagestartswithpageST_AsBinarypageST_AsTextpageST_ContainspageST_DistancepageST_GeogFromTextpageST_GeogFromWKBpageST_GeometryTypepageST_GeomFromTextpageST_GeomFromWKBpageSTPOINTpageST_PolygonpagestrpospageST_UnionpageSUBpagesubstrpagesumpageTIMECONVERTurlhttps://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