Functions

This page contains reference documentation for functions in Apache Pinot.

This page contains reference documentation for functions in Apache Pinot.

ABSADDarrayConcatDoublearrayConcatFloatarrayConcatIntarrayConcatLongarrayConcatStringarrayContainsIntarrayContainsStringarrayDistinctIntarrayDistinctStringarrayIndexOfIntarrayIndexOfStringARRAYLENGTHarrayRemoveIntarrayRemoveStringarrayReverseIntarrayReverseStringarraySliceIntarraySliceStringarraySortIntarraySortStringarrayUnionIntarrayUnionStringAVGMVBase64caseWhenceilCHRhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/clpdecode.mdcodepointconcatcountCOUNTMVDATETIMECONVERTDATETRUNCdaydayOfWeekdayOfYearDISTINCTDISTINCTCOUNTDISTINCTCOUNTBITMAPDISTINCTCOUNTHLLMVDISTINCTCOUNTHLLDISTINCTCOUNTBITMAPMVhttps://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.mdDISTINCTCOUNTRAWTHETASKETCHDISTINCTCOUNTRAWHLLDISTINCTCOUNTTHETASKETCHDISTINCTCOUNTTHETASKETCHDISTINCTCOUNTHLLDISTINCTSUMDISTINCTSUMMVDIVexpExtractFIRSTWITHTIMEFrequentLongsSketchFrequentStringsSketchFromDateTimeFLOORFromEpochFromEpochBucketHistogramhourjsonextractkeyjsonextractscalarJSONFORMATJSONPATHJSONPATHARRAYJSONPATHARRAYDEFAULTEMPTYJSONPATHDOUBLEJSONPATHLONGJSONPATHSTRINGLAGLASTWITHTIMELEADlengthlnlowerlpadltrimmaxMAXMVMD5millisecondminminmaxrangeMINMAXRANGEMVMINMVminuteMODmodemonthmultnowpercentilepercentileestpercentileestmvpercentiletdigestpercentiletdigestmvpercentilemvpercentilekllpercentilerawkllpercentilekllmvpercentilerawkllmvquarterregexpExtractremovereplacereverseroundROW_NUMBERrpadrtrimsecondSEGMENTPARTITIONEDDISTINCTCOUNTshasha256sha512sqrtstartswithST_AsBinaryST_AsTextST_ContainsST_DistanceST_GeogFromTextST_GeogFromWKBST_GeometryTypeST_GeomFromTextST_GeomFromWKBSTPOINTST_PolygonstrposST_UnionSUBsubstrsumsummvTIMECONVERTtimezoneHourtimezoneMinuteToDateTimeToEpochToEpochBucketToEpochRoundedTOJSONMAPSTRtoSphericalGeographytrimupperUrlUTF8VALUEINweekyearyearOfWeek