Available Functions

Supported functions

abs accurateCast accurateCastOrNull acos acosh addDays addHours addMinutes addMonths addQuarters addSeconds addWeeks addYears age alphaTokens and any anyHeavy anyLast appendTrailingCharIfAbsent argMax argMaxMerge argMaxState argMin argMinMerge argMinState array array_agg arrayAll arrayAUC arrayAvg arrayCompact arrayConcat arrayCount arrayCumSum arrayCumSumNonNegative arrayDifference arrayDistinct arrayElement arrayEnumerate arrayEnumerateDense arrayEnumerateUniq arrayExists arrayFill arrayFilter arrayFirst arrayFirstIndex arrayFlatten arrayFold arrayIntersect arrayJoin arrayLast arrayLastIndex arrayMap arrayMax arrayMin arrayPopBack arrayPopFront arrayProduct arrayPushBack arrayPushFront arrayReduce arrayResize arrayReverse arrayReverseFill arrayReverseSort arrayReverseSplit arrayRotateLeft arrayRotateRight arraySlice arraySort arraySplit arrayStringConcat arraySum arrayUniq arrayWithConstant arrayZip ascii asin asinh assumeNotNull atan atan2 atanh avg avgArgMax avgArgMaxOrDefault avgArgMaxOrNull avgArgMin avgArgMinOrDefault avgArgMinOrNull avgArray avgArrayOrDefault avgArrayOrNull avgForEach avgForEachOrDefault avgForEachOrNull avgMap avgMapMerge avgMapOrDefault avgMapOrNull avgMapState avgMerge avgMergeOrDefault avgMergeOrNull avgOrDefault avgOrNull avgState avgStateOrDefault avgStateOrNull avgWeighted bar base58Decode base58Encode base64Decode base64Encode bitAnd bitCount bitHammingDistance bitmapAnd bitmapAndCardinality bitmapAndnot bitmapAndnotCardinality bitmapBuild bitmapCardinality bitmapContains bitmapHasAll bitmapHasAny bitmapMax bitmapMin bitmapOr bitmapOrCardinality bitmapSubsetInRange bitmapSubsetLimit bitmapToArray bitmapTransform bitmapXor bitmapXorCardinality bitNot bitOr bitRotateLeft bitRotateRight bitShiftLeft bitShiftRight bitSlice bitTest bitTestAll bitTestAny bitXor btrim cbrt ceil cityHash64 coalesce concat concatWithSeparator contingency convertCharset corr cos cosh cosineDistance count countArgMax countArgMaxOrDefault countArgMaxOrNull countArgMin countArgMinOrDefault countArgMinOrNull countArray countArrayOrDefault countArrayOrNull countDistinct countDistinctArgMax countDistinctArgMaxOrDefault countDistinctArgMaxOrNull countDistinctArgMin countDistinctArgMinOrDefault countDistinctArgMinOrNull countDistinctArray countDistinctArrayOrDefault countDistinctArrayOrNull countDistinctForEach countDistinctForEachOrDefault countDistinctForEachOrNull countDistinctMap countDistinctMapOrDefault countDistinctMapOrNull countDistinctMerge countDistinctMergeOrDefault countDistinctMergeOrNull countDistinctOrDefault countDistinctOrNull countDistinctState countDistinctStateOrDefault countDistinctStateOrNull countEqual countForEach countForEachOrDefault countForEachOrNull countMap countMapOrDefault countMapOrNull countMatches countMatchesCaseInsensitive countMerge countMergeOrDefault countMergeOrNull countOrDefault countOrNull countState countStateOrDefault countStateOrNull countSubstrings countSubstringsCaseInsensitive countSubstringsCaseInsensitiveUTF8 covarPop covarSamp cramersV cramersVBiasCorrected current_date current_timestamp cutFragment cutIPv6 cutQueryString cutQueryStringAndFragment cutToFirstSignificantSubdomain cutToFirstSignificantSubdomainWithWWW cutURLParameter cutWWW date_add date_bin date_diff date_part date_subtract date_trunc dateAdd dateDiff dateName dateSub dateTrunc decodeURLComponent decodeURLFormComponent decodeXMLComponent defaultValueOfTypeName degrees deltaSum deltaSumTimestamp dense_rank divide divideDecimal domain domainWithoutWWW dotProduct dynamicType e empty encodeURLComponent encodeURLFormComponent encodeXMLComponent endsWith equals erf erfc every exp exp10 exp2 extract extractAll extractAllGroups extractAllGroupsHorizontal extractAllGroupsVertical extractGroups extractIPv4Substrings extractTextFromHTML extractURLParameter extractURLParameterNames extractURLParameters factorial first_value firstSignificantSubdomain floor format formatDateTime formatReadableDecimalSize formatReadableQuantity formatReadableSize formatReadableTimeDelta fragment fromModifiedJulianDay fromUnixTimestamp fromUnixTimestamp64Milli gcd generateSeries geoDistance geohashDecode geohashEncode geohashesInBox geoToH3 greatCircleAngle greatCircleDistance greater greaterOrEquals greatest groupArray groupArrayInsertAt groupArrayMovingAvg groupArrayMovingSum groupArraySample groupBitAnd groupBitmap groupBitmapAnd groupBitmapAndState groupBitmapOr groupBitmapOrState groupBitmapState groupBitmapXor groupBitOr groupBitXor groupUniqArray groupUniqArrayArray h3CellAreaM2 h3CellAreaRads2 h3Distance h3EdgeAngle h3EdgeLengthKm h3EdgeLengthM h3ExactEdgeLengthKm h3ExactEdgeLengthM h3ExactEdgeLengthRads h3GetBaseCell h3GetDestinationIndexFromUnidirectionalEdge h3GetFaces h3GetIndexesFromUnidirectionalEdge h3GetOriginIndexFromUnidirectionalEdge h3GetPentagonIndexes h3GetRes0Indexes h3GetResolution h3GetUnidirectionalEdge h3GetUnidirectionalEdgeBoundary h3GetUnidirectionalEdgesFromHexagon h3HexAreaKm2 h3HexAreaM2 h3HexRing h3IndexesAreNeighbors h3IsPentagon h3IsResClassIII h3IsValid h3kRing h3Line h3NumHexagons h3PointDistKm h3PointDistM h3PointDistRads h3ToCenterChild h3ToChildren h3ToGeo h3ToGeoBoundary h3ToParent h3ToString h3UnidirectionalEdgeIsValid has hasAll hasAllTokens hasAny hasAnyTokens hasSubsequence hasSubsequenceCaseInsensitive hasSubsequenceCaseInsensitiveUTF8 hasSubsequenceUTF8 hasSubstr hasToken hasTokenCaseInsensitive hasTokenCaseInsensitiveOrNull hasTokenOrNull hex hop hopEnd hopStart hypot if ifNotFinite ifnull ilike in indexHint indexOf initcap intDiv intDivOrZero intExp10 intExp2 IPv4CIDRToRange IPv4NumToString IPv4StringToNum IPv4StringToNumOrDefault IPv4StringToNumOrNull IPv4ToIPv6 IPv6CIDRToRange IPv6NumToString IPv6StringToNum IPv6StringToNumOrDefault IPv6StringToNumOrNull isFinite isInfinite isIPAddressInRange isIPv4String isIPv6String isNaN isNotNull isnull isValidJSON isValidUTF8 json_agg JSON_VALUE JSONArrayLength JSONExtract JSONExtractArrayRaw JSONExtractBool JSONExtractFloat JSONExtractInt JSONExtractKeys JSONExtractKeysAndValues JSONExtractKeysAndValuesRaw JSONExtractRaw JSONExtractString JSONExtractUInt JSONHas JSONLength JSONType kurtPop kurtSamp L1Distance L1Norm L1Normalize L2Distance L2Norm L2Normalize lag lagInFrame languageCodeToName last_value lcm lead leadInFrame least left leftPad leftPadUTF8 length lengthUTF8 less lessOrEquals lgamma like LinfDistance LinfNorm LinfNormalize ln locate log log10 log1p log2 lower lowerUTF8 lpad LpDistance LpNorm LpNormalize ltrim make_date make_interval make_timestamp make_timestamptz map mapAdd mapApply mapContains mapContainsKeyLike mapExtractKeyLike mapFilter mapFromArrays mapKeys mapPopulateSeries mapSubtract mapUpdate mapValues match max max2 maxArgMax maxArgMaxOrDefault maxArgMaxOrNull maxArgMin maxArgMinOrDefault maxArgMinOrNull maxArray maxArrayOrDefault maxArrayOrNull maxForEach maxForEachOrDefault maxForEachOrNull maxIntersections maxIntersectionsPosition maxMap maxMapOrDefault maxMapOrNull maxMerge maxMergeOrDefault maxMergeOrNull maxOrDefault maxOrNull maxState maxStateOrDefault maxStateOrNull md5 MD5 median medianArgMax medianArgMaxOrDefault medianArgMaxOrNull medianArgMin medianArgMinOrDefault medianArgMinOrNull medianArray medianArrayOrDefault medianArrayOrNull medianBFloat16 medianDeterministic medianExact medianExactHigh medianExactLow medianExactWeighted medianForEach medianForEachOrDefault medianForEachOrNull medianMap medianMapOrDefault medianMapOrNull medianMerge medianMergeOrDefault medianMergeOrNull medianOrDefault medianOrNull medianState medianStateOrDefault medianStateOrNull medianTDigest medianTDigestWeighted medianTiming medianTimingWeighted min min2 minArgMax minArgMaxOrDefault minArgMaxOrNull minArgMin minArgMinOrDefault minArgMinOrNull minArray minArrayOrDefault minArrayOrNull minForEach minForEachOrDefault minForEachOrNull minMap minMapOrDefault minMapOrNull minMerge minMergeOrDefault minMergeOrNull minOrDefault minOrNull minState minStateOrDefault minStateOrNull minus modulo moduloOrZero monthName multiFuzzyMatchAllIndices multiFuzzyMatchAny multiFuzzyMatchAnyIndex multiIf multiMatchAllIndices multiMatchAny multiMatchAnyIndex multiply multiplyDecimal multiSearchAllPositions multiSearchAllPositionsCaseInsensitive multiSearchAllPositionsCaseInsensitiveUTF8 multiSearchAllPositionsUTF8 multiSearchAny multiSearchAnyCaseInsensitive multiSearchAnyCaseInsensitiveUTF8 multiSearchAnyUTF8 multiSearchFirstIndex multiSearchFirstIndexCaseInsensitive multiSearchFirstIndexCaseInsensitiveUTF8 multiSearchFirstIndexUTF8 multiSearchFirstPosition multiSearchFirstPositionCaseInsensitive multiSearchFirstPositionCaseInsensitiveUTF8 multiSearchFirstPositionUTF8 negate netloc ngramDistance ngramDistanceCaseInsensitive ngramDistanceCaseInsensitiveUTF8 ngramDistanceUTF8 ngrams ngramSearch ngramSearchCaseInsensitive ngramSearchCaseInsensitiveUTF8 ngramSearchUTF8 not notEmpty notEquals notILike notIn notLike now nowInBlock nth_value nullif or parseDateTime parseDateTimeBestEffort path pathFull percentile_cont percentile_disc pi plus pointInEllipses pointInPolygon port position positionCaseInsensitive positionCaseInsensitiveUTF8 positionUTF8 positiveModulo pow power protocol quantile quantileExact quantiles quantilesMerge quantilesState queryString queryStringAndFragment radians rand range rank regexpExtract regexpQuoteMeta reinterpretAsFloat32 reinterpretAsFloat64 reinterpretAsInt128 reinterpretAsInt16 reinterpretAsInt256 reinterpretAsInt32 reinterpretAsInt64 reinterpretAsInt8 reinterpretAsUInt128 reinterpretAsUInt16 reinterpretAsUInt256 reinterpretAsUInt32 reinterpretAsUInt64 reinterpretAsUInt8 reinterpretAsUUID repeat replace replaceAll replaceOne replaceRegexpAll replaceRegexpOne reverse reverseUTF8 right rightPad rightPadUTF8 round roundAge roundBankers roundDown roundDuration roundToExp2 row_number rowNumberInAllBlocks rowNumberInBlock rpad rtrim sign simpleLinearRegression sin sinh skewPop skewSamp split_part splitByChar splitByNonAlpha splitByRegexp splitByString splitByWhitespace sqrt startsWith stddevPop stddevSamp string_agg stringToH3 subBitmap substring substringUTF8 subtractDays subtractHours subtractMinutes subtractMonths subtractQuarters subtractSeconds subtractWeeks subtractYears sum sumArgMax sumArgMaxOrDefault sumArgMaxOrNull sumArgMin sumArgMinOrDefault sumArgMinOrNull sumArray sumArrayOrDefault sumArrayOrNull sumForEach sumForEachMerge sumForEachOrDefault sumForEachOrNull sumForEachState sumMap sumMapMerge sumMapOrDefault sumMapOrNull sumMerge sumMergeOrDefault sumMergeOrNull sumOrDefault sumOrNull sumState sumStateOrDefault sumStateOrNull sumWithOverflow tan tgamma theilsU throwIf timeSlot timeSlots timeStampAdd timeStampSub timezone timeZoneOf timeZoneOffset to_char to_date to_timestamp toBool toDate toDateTime toDateTime64 toDateTimeUS today toDayOfMonth toDayOfWeek toDayOfYear toDecimal toFloat toFloat64OrNull toFloatOrDefault toFloatOrNull toFloatOrZero toHour toInt toIntervalDay toIntervalHour toIntervalMinute toIntervalMonth toIntervalQuarter toIntervalSecond toIntervalWeek toIntervalYear toIntOrDefault toIntOrZero toIPv4 toIPv4OrDefault toIPv4OrNull toIPv4OrZero toIPv6 toIPv6OrDefault toIPv6OrNull toIPv6OrZero toISOWeek toISOYear toJSONString tokens toLastDayOfMonth toLastDayOfWeek toMinute toModifiedJulianDay toMonday toMonth toNullable toNullableString topK topLevelDomain toQuarter toSecond toStartOfDay toStartOfFifteenMinutes toStartOfFiveMinutes toStartOfHour toStartOfInterval toStartOfISOYear toStartOfMinute toStartOfMonth toStartOfQuarter toStartOfSecond toStartOfTenMinutes toStartOfWeek toStartOfYear toString toTime toTimeZone toTypeName toUnixTimestamp toUnixTimestamp64Milli toUUID toUUIDOrDefault toValidUTF8 toWeek toYear toYearWeek toYYYYMM toYYYYMMDD toYYYYMMDDhhmmss transform translate translateUTF8 trim trimLeft trimRight trunc tryBase58Decode tryBase64Decode tumble tumbleEnd tumbleStart tuple tupleDivide tupleDivideByNumber tupleElement tupleHammingDistance tupleMinus tupleMultiply tupleMultiplyByNumber tupleNegate tuplePlus tupleToNameValuePairs unhex uniq uniqCombined uniqCombined64 uniqExact uniqExactMerge uniqExactState uniqHLL12 uniqMap uniqMapMerge uniqMerge uniqState uniqTheta uniqUpToMerge untuple upper upperUTF8 URLHierarchy URLPathHierarchy UUIDv7ToDateTime varPop varSamp width_bucket windowFunnel xor yesterday