Functions

This page contains reference documentation for functions in Apache Pinot.

This page contains reference documentation for functions in Apache Pinot.

ABSADDarrayConcatDoublearrayConcatFloatarrayConcatIntarrayConcatLongarrayConcatStringarrayContainsIntarrayContainsStringarrayDistinctIntarrayDistinctStringarrayIndexOfIntarrayIndexOfStringARRAYLENGTHarrayRemoveIntarrayRemoveStringarrayReverseIntarrayReverseStringarraySliceIntarraySliceStringarraySortIntarraySortStringarrayUnionIntarrayUnionStringAVGMVBase64caseWhenceilCHRcodepointconcatcountCOUNTMVDATETIMECONVERTDATETRUNCdaydayOfWeekdayOfYearDISTINCTDISTINCTCOUNTDISTINCTCOUNTBITMAPDISTINCTCOUNTHLLMVDISTINCTCOUNTHLLDISTINCTCOUNTBITMAPMVDISTINCTCOUNTMVDISTINCTCOUNTRAWHLLDISTINCTCOUNTRAWHLLMVDISTINCTCOUNTRAWTHETASKETCHDISTINCTCOUNTTHETASKETCHDIVexpExtractFromDateTimeFLOORFromEpochFromEpochBucketHistogramhourjsonextractkeyjsonextractscalarJSONFORMATJSONPATHJSONPATHARRAYJSONPATHARRAYDEFAULTEMPTYJSONPATHDOUBLEJSONPATHLONGJSONPATHSTRINGlengthlnlowerlpadltrimmaxMAXMVMD5millisecondminminmaxrangeMINMAXRANGEMVMINMVminuteMODmodemonthmultnowpercentilepercentileestpercentileestmvpercentiletdigestpercentiletdigestmvpercentilemvpercentilekllpercentilerawkllpercentilekllmvpercentilerawkllmvquarterregexpExtractremovereplacereverseround
rpadrtrimsecondSEGMENTPARTITIONEDDISTINCTCOUNTshasha256sha512sqrtstartswithST_AsBinaryST_AsTextST_ContainsST_DistanceST_GeogFromTextST_GeogFromWKBST_GeometryTypeST_GeomFromTextST_GeomFromWKBSTPOINTST_PolygonstrposST_UnionSUBsubstrsumTIMECONVERThttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/timezoneHour.mdhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/timezoneMinute.mdToDateTimehttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/toEpoch.mdhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/toEpochBucket.mdhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/toEpochRounded.mdTOJSONMAPSTRtoSphericalGeographytrimupperUrlUTF8VALUEINweekyearhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/yearOfWeek.md