Function List

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

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

Last updated

Was this helpful?