Functions

This page contains reference documentation for functions in Apache Pinot.

This page contains reference documentation for functions in Apache Pinot.

ABSADDarrayConcatDoublearrayConcatFloatarrayConcatIntarrayConcatLongarrayConcatStringarrayContainsIntarrayContainsStringarrayDistinctIntarrayDistinctStringarrayIndexOfIntarrayIndexOfStringARRAYLENGTHarrayRemoveIntarrayRemoveStringarrayReverseIntarrayReverseStringarraySliceIntarraySliceStringarraySortIntarraySortStringarrayUnionIntarrayUnionStringAVGMVhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/avgvalueintegersumtuplesketch.mdBase64caseWhenceilCHRhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/clpdecode.mdcodepointconcatcountCOUNTMVDATETIMECONVERTDATETRUNCdaydayOfWeekdayOfYearDISTINCTDISTINCTCOUNTDISTINCTCOUNTBITMAPDISTINCTCOUNTHLLMVDISTINCTCOUNTHLLDISTINCTCOUNTBITMAPMVDISTINCTCOUNTMVDISTINCTCOUNTRAWHLLDISTINCTCOUNTRAWHLLMVhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawcpcsketch.mdDISTINCTCOUNTRAWTHETASKETCHhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawintegersumtuplesketch.mdhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountrawull.mdhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountcpcsketch.mdDISTINCTCOUNTTHETASKETCHhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcounttuplesketch.mdhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/distinctcountull.mdDIVexpExtractFIRSTWITHTIMEhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/freqeuentlongssketch.mdhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/frequentstringsketch.mdFromDateTimeFLOORFromEpochFromEpochBucketHistogramhourjsonextractkeyjsonextractscalarJSONFORMATJSONPATHJSONPATHARRAYJSONPATHARRAYDEFAULTEMPTYJSONPATHDOUBLEJSONPATHLONGJSONPATHSTRINGLASTWITHTIMElengthlnlowerlpadltrimmaxMAXMVMD5millisecondminminmaxrangeMINMAXRANGEMVMINMVminuteMODmodemonthmultnowpercentilepercentileestpercentileestmvpercentiletdigestpercentiletdigestmvpercentilemvpercentilekllpercentilerawkllpercentilekllmvpercentilerawkllmvquarterregexpExtractremovereplacereverseroundROW_NUMBERrpadrtrimsecondSEGMENTPARTITIONEDDISTINCTCOUNTshasha256sha512sqrtstartswithST_AsBinaryST_AsTextST_ContainsST_DistanceST_GeogFromTextST_GeogFromWKBST_GeometryTypeST_GeomFromTextST_GeomFromWKBSTPOINTST_PolygonstrposST_UnionSUBsubstrsumhttps://github.com/pinot-contrib/pinot-docs/blob/latest/configuration-reference/functions/sumvaluesintegersumtuplesketch.mdTIMECONVERThttps://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