Function List

This page is deprecating, we are moving all the below functions into the relevant categories in this section.

Since the functions are too many and there is not point to make a full list here just for function name checking.

We decided to segregate functions into its usage and re-organize them.

This page contains reference documentation for functions in Apache Pinot.

ABSADDARRAY_AGGarrayConcatDoublearrayConcatFloatarrayConcatIntarrayConcatLongarrayConcatStringarrayContainsIntarrayContainsStringarrayDistinctIntarrayDistinctStringarrayIndexOfIntarrayIndexOfStringARRAYLENGTHarrayRemoveIntarrayRemoveStringarrayReverseIntarrayReverseStringarraySliceIntarraySliceStringarraySortIntarraySortStringarrayUnionIntarrayUnionStringAVGMVBase64caseWhenceilCHRhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/clpdecode.mdcodepointconcatcountCOUNTMVDATETIMECONVERTDATETRUNCdaydayOfWeekdayOfYearDISTINCTDISTINCTCOUNTDISTINCTCOUNTBITMAPDISTINCTCOUNTBITMAPMVDISTINCTCOUNTHLLDISTINCTCOUNTHLLMVhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcounthllplus.mdhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcounthllplusmv.mdDISTINCTCOUNTMVDISTINCTCOUNTRAWHLLhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawhllplus.mdDISTINCTCOUNTRAWHLLMVhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawhllplusmv.mdhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawcpcsketch.mdDISTINCTCOUNTRAWTHETASKETCHDISTINCTCOUNTRAWHLLDISTINCTCOUNTTHETASKETCHDISTINCTCOUNTTHETASKETCHDISTINCTCOUNTHLLDISTINCTSUMDISTINCTSUMMVDIVexpExtractFIRSTWITHTIMEFrequentLongsSketchFrequentStringsSketchFromDateTimeFLOORFromEpochFromEpochBucketGridDistanceHistogramhourjsonextractkeyjsonextractscalarJSONFORMATJSONPATHJSONPATHARRAYJSONPATHARRAYDEFAULTEMPTYJSONPATHDOUBLEJSONPATHLONGJSONPATHSTRINGLAGLASTWITHTIMELEADlengthlnlowerlpadltrimmaxMAXMVMD5millisecondminminmaxrangeMINMAXRANGEMVMINMVminuteMODmodemonthmultnowpercentilepercentileestpercentileestmvpercentiletdigestpercentiletdigestmvpercentilemvpercentilekllpercentilerawkllpercentilekllmvpercentilerawkllmvquarterregexpExtractremovereplacereverseroundROW_NUMBERrpadrtrimsecondSEGMENTPARTITIONEDDISTINCTCOUNTshasha256sha512sqrtstartswithST_AsBinaryST_AsGeoJSONST_AsTextST_ContainsST_DistanceST_GeogFromGeoJSONST_GeogFromTextST_GeogFromWKBST_GeometryTypeST_GeomFromGeoJSONST_GeomFromTextST_GeomFromWKBSTPOINTST_PolygonstrposST_UnionSUBsubstrsumsummvTIMECONVERTtimezoneHourtimezoneMinuteToDateTimeToEpochToEpochBucketToEpochRoundedTOJSONMAPSTRtoSphericalGeographytrimupperUrlUTF8VALUEINweekyearyearOfWeek