ClickHouse Function Availability Reference

This tool provides information about function and keyword availability across a range of recent ClickHouse releases, sourced from the system.functions, system.keywords, and system.functions tables for each release.

headlatest25.124.1224.1124.1024.924.824.724.624.524.424.324.224.123.1223.1123.1023.923.823.723.623.523.423.323.223.122.1222.1122.1022.922.822.322.121.1221.1121.1021.9
BIT_AND*
BIT_OR*
BIT_XOR*
BLAKE3
CAST
CHARACTER_LENGTH*
CHAR_LENGTH*
COVAR_POP*
COVAR_SAMP*
CRC32
CRC32IEEE
CRC64
DATABASE*
DATE
DATE_DIFF*
DATE_FORMAT*
DATE_TRUNC*
DAY*
DAYOFMONTH*
DAYOFWEEK*
DAYOFYEAR*
FORMAT_BYTES*
FQDN
FROM_BASE64*
FROM_DAYS*
FROM_UNIXTIME*
HOP
HOP_END
HOP_START
HOUR*
INET6_ATON*
INET6_NTOA*
INET_ATON*
INET_NTOA*
IPv4CIDRToRange
IPv4NumToString
IPv4NumToStringClassC
IPv4StringToNum
IPv4StringToNumOrDefault
IPv4StringToNumOrNull
IPv4ToIPv6
IPv6CIDRToRange
IPv6NumToString
IPv6StringToNum
IPv6StringToNumOrDefault
IPv6StringToNumOrNull
JSONAllPaths
JSONAllPathsWithTypes
JSONArrayLength
JSONDynamicPaths
JSONDynamicPathsWithTypes
JSONExtract
JSONExtractArrayRaw
JSONExtractBool
JSONExtractFloat
JSONExtractInt
JSONExtractKeys
JSONExtractKeysAndValues
JSONExtractKeysAndValuesRaw
JSONExtractRaw
JSONExtractString
JSONExtractUInt
JSONHas
JSONKey
JSONLength
JSONMergePatch
JSONSharedDataPaths
JSONSharedDataPathsWithTypes
JSONType
JSON_ARRAY_LENGTH*
JSON_EXISTS
JSON_QUERY
JSON_VALUE
L1Distance
L1Norm
L1Normalize
L2Distance
L2Norm
L2Normalize
L2SquaredDistance
L2SquaredNorm
LAST_DAY*
LinfDistance
LinfNorm
LinfNormalize
LpDistance
LpNorm
LpNormalize
MACNumToString
MACStringToNum
MACStringToOUI
MAP_FROM_ARRAYS*
MD4
MD5
MILLISECOND*
MINUTE*
MONTH*
OCTET_LENGTH*
QUARTER*
REGEXP_EXTRACT*
REGEXP_MATCHES*
REGEXP_REPLACE*
RIPEMD160
SCHEMA*
SECOND*
SHA1
SHA224
SHA256
SHA384
SHA512
SHA512_256
STD*
STDDEV_POP*
STDDEV_SAMP*
SUBSTRING_INDEX*
SVG*
TIMESTAMP_DIFF*
TO_BASE64*
TO_DAYS*
TO_UNIXTIME*
TUMBLE
TUMBLE_END
TUMBLE_START
TimeDiff
ULIDStringToDateTime
URLHash
URLHierarchy
URLPathHierarchy
UTCTimestamp
UTC_timestamp*
UUIDNumToString
UUIDStringToNum
UUIDToNum
UUIDv7ToDateTime
VAR_POP*
VAR_SAMP*
WINDOW_ID
YEAR*
YYYYMMDDToDate
YYYYMMDDToDate32
YYYYMMDDhhmmssToDateTime
YYYYMMDDhhmmssToDateTime64
_CAST
__actionName
__bitBoolMaskAnd
__bitBoolMaskOr
__bitSwapLastTwo
__bitWrapperFunc
__getScalar
__scalarSubqueryResult
abs
accurateCast
accurateCastOrDefault
accurateCastOrNull
accurate_Cast
accurate_CastOrNull
acos
acosh
addDate
addDays
addHours
addInterval
addMicroseconds
addMilliseconds
addMinutes
addMonths
addNanoseconds
addQuarters
addSeconds
addTupleOfIntervals
addWeeks
addYears
addressToLine
addressToLineWithInlines
addressToSymbol
aes_decrypt_mysql
aes_encrypt_mysql
age
aggThrow
alphaTokens
analysisOfVariance
and
anova*
any
anyHeavy
anyLast
anyLastRespectNulls*
anyLast_respect_nulls
anyRespectNulls*
anyValueRespectNulls*
any_respect_nulls
any_value*
any_value_respect_nulls*
appendTrailingCharIfAbsent
approx_top_count*
approx_top_k
approx_top_sum
argMax
argMin
array
arrayAUC*
arrayAUCPR
arrayAll
arrayAvg
arrayCompact
arrayConcat
arrayCount
arrayCumSum
arrayCumSumNonNegative
arrayDifference
arrayDistinct
arrayDotProduct
arrayElement
arrayElementOrNull
arrayEnumerate
arrayEnumerateDense
arrayEnumerateDenseRanked
arrayEnumerateUniq
arrayEnumerateUniqRanked
arrayExists
arrayFill
arrayFilter
arrayFirst
arrayFirstIndex
arrayFirstOrNull
arrayFlatten
arrayFold
arrayIntersect
arrayJaccardIndex
arrayJoin
arrayLast
arrayLastIndex
arrayLastOrNull
arrayMap
arrayMax
arrayMin
arrayNormalizedGini
arrayPRAUC*
arrayPartialReverseSort
arrayPartialShuffle
arrayPartialSort
arrayPopBack
arrayPopFront
arrayProduct
arrayPushBack
arrayPushFront
arrayROCAUC
arrayRandomSample
arrayReduce
arrayReduceInRanges
arrayResize
arrayReverse
arrayReverseFill
arrayReverseSort
arrayReverseSplit
arrayRotateLeft
arrayRotateRight
arrayShiftLeft
arrayShiftRight
arrayShingles
arrayShuffle
arraySlice
arraySort
arraySplit
arrayStringConcat
arraySum
arraySymmetricDifference
arrayUnion
arrayUniq
arrayWithConstant
arrayZip
arrayZipUnaligned
array_agg*
array_concat_agg*
ascii
asin
asinh
assumeNotNull
atan
atan2
atanh
avg
avgWeighted
bar
base58Decode
base58Encode
base64Decode
base64Encode
base64URLDecode
base64URLEncode
basename
bayesAB
bin
bitAnd
bitCount
bitHammingDistance
bitNot
bitOr
bitPositionsToArray
bitRotateLeft
bitRotateRight
bitShiftLeft
bitShiftRight
bitSlice
bitTest
bitTestAll
bitTestAny
bitXor
bitmapAnd
bitmapAndCardinality
bitmapAndnot
bitmapAndnotCardinality
bitmapBuild
bitmapCardinality
bitmapContains
bitmapHasAll
bitmapHasAny
bitmapMax
bitmapMin
bitmapOr
bitmapOrCardinality
bitmapSubsetInRange
bitmapSubsetLimit
bitmapToArray
bitmapTransform
bitmapXor
bitmapXorCardinality
bitmaskToArray
bitmaskToList
blockNumber
blockSerializedSize
blockSize
boundingRatio
buildId
byteHammingDistance
byteSize
byteSlice*
byteSwap
caseWithExpr*
caseWithExpression
caseWithoutExpr*
caseWithoutExpression*
catboostEvaluate
categoricalInformationValue
cbrt
ceil
ceiling*
changeDay
changeHour
changeMinute
changeMonth
changeSecond
changeYear
char
cityHash64
clamp
coalesce
compareSubstrings
concat
concatAssumeInjective
concatWithSeparator
concatWithSeparatorAssumeInjective
concat_ws*
connectionId
connection_id*
contingency
convertCharset
corr
corrMatrix
corrStable
cos
cosh
cosineDistance
count
countDigits
countEqual
countMatches
countMatchesCaseInsensitive
countSubstrings
countSubstringsCaseInsensitive
countSubstringsCaseInsensitiveUTF8
covarPop
covarPopMatrix
covarPopStable
covarSamp
covarSampMatrix
covarSampStable
cramersV
cramersVBiasCorrected
curdate*
currentDatabase
currentProfiles
currentQueryID
currentRoles
currentSchemas
currentUser
current_database*
current_date*
current_query_id*
current_schemas*
current_timestamp*
current_user*
cutFragment
cutIPv6
cutQueryString
cutQueryStringAndFragment
cutToFirstSignificantSubdomain
cutToFirstSignificantSubdomainCustom
cutToFirstSignificantSubdomainCustomRFC
cutToFirstSignificantSubdomainCustomWithWWW
cutToFirstSignificantSubdomainCustomWithWWWRFC
cutToFirstSignificantSubdomainRFC
cutToFirstSignificantSubdomainWithWWW
cutToFirstSignificantSubdomainWithWWWRFC
cutURLParameter
cutWWW
damerauLevenshteinDistance
dateDiff
dateName
dateTime64ToSnowflake
dateTime64ToSnowflakeID
dateTimeToSnowflake
dateTimeToSnowflakeID
dateTrunc*
date_bin*
date_diff*
date_trunc
decodeHTMLComponent
decodeURLComponent
decodeURLFormComponent
decodeXMLComponent
decrypt
defaultProfiles
defaultRoles
defaultValueOfArgumentType
defaultValueOfTypeName
degrees
deltaSum
deltaSumTimestamp
demangle
denseRank
dense_rank*
detectCharset
detectLanguage
detectLanguageMixed
detectLanguageUnknown
detectProgrammingLanguage
detectTonality
dictGet
dictGetAll
dictGetChildren
dictGetDate
dictGetDateOrDefault
dictGetDateTime
dictGetDateTimeOrDefault
dictGetDescendants
dictGetFloat32
dictGetFloat32OrDefault
dictGetFloat64
dictGetFloat64OrDefault
dictGetHierarchy
dictGetIPv4
dictGetIPv4OrDefault
dictGetIPv6
dictGetIPv6OrDefault
dictGetInt16
dictGetInt16OrDefault
dictGetInt32
dictGetInt32OrDefault
dictGetInt64
dictGetInt64OrDefault
dictGetInt8
dictGetInt8OrDefault
dictGetOrDefault
dictGetOrNull
dictGetString
dictGetStringOrDefault
dictGetUInt16
dictGetUInt16OrDefault
dictGetUInt32
dictGetUInt32OrDefault
dictGetUInt64
dictGetUInt64OrDefault
dictGetUInt8
dictGetUInt8OrDefault
dictGetUUID
dictGetUUIDOrDefault
dictHas
dictIsIn
displayName
distanceL1*
distanceL2*
distanceL2Squared*
distanceLinf*
distanceLp*
distinctDynamicTypes
distinctJSONPaths
distinctJSONPathsAndTypes
divide
divideDecimal
domain
domainRFC
domainWithoutWWW
domainWithoutWWWRFC
dotProduct
dumpColumnStructure
dynamicElement
dynamicType
e
editDistance
editDistanceUTF8
empty
emptyArrayDate
emptyArrayDateTime
emptyArrayFloat32
emptyArrayFloat64
emptyArrayInt16
emptyArrayInt32
emptyArrayInt64
emptyArrayInt8
emptyArrayString
emptyArrayToSingle
emptyArrayUInt16
emptyArrayUInt32
emptyArrayUInt64
emptyArrayUInt8
enabledProfiles
enabledRoles
encodeURLComponent
encodeURLFormComponent
encodeXMLComponent
encrypt
endsWith
endsWithUTF8
entropy
equals
erf
erfc
errorCodeToName
evalMLMethod
exp
exp10
exp2
exponentialMovingAverage
exponentialTimeDecayedAvg
exponentialTimeDecayedCount
exponentialTimeDecayedMax
exponentialTimeDecayedSum
extract
extractAll
extractAllGroups*
extractAllGroupsHorizontal
extractAllGroupsVertical
extractGroups
extractKeyValuePairs
extractKeyValuePairsWithEscaping
extractTextFromHTML
extractURLParameter
extractURLParameterNames
extractURLParameters
factorial
farmFingerprint64
farmHash64
file
filesystemAvailable
filesystemCapacity
filesystemFree
filesystemUnreserved
finalizeAggregation
firstLine
firstSignificantSubdomain
firstSignificantSubdomainCustom
firstSignificantSubdomainCustomRFC
firstSignificantSubdomainRFC
firstValueRespectNulls*
first_value*
first_value_respect_nulls*
flameGraph
flatten*
flattenTuple
floor
format
formatDateTime
formatDateTimeInJodaSyntax
formatQuery
formatQueryOrNull
formatQuerySingleLine
formatQuerySingleLineOrNull
formatReadableDecimalSize
formatReadableQuantity
formatReadableSize
formatReadableTimeDelta
formatRow
formatRowNoNewline
fragment
fromDaysSinceYearZero
fromDaysSinceYearZero32
fromModifiedJulianDay
fromModifiedJulianDayOrNull
fromUTCTimestamp
fromUnixTimestamp*
fromUnixTimestamp64Micro
fromUnixTimestamp64Milli
fromUnixTimestamp64Nano
fromUnixTimestamp64Second
fromUnixTimestampInJodaSyntax
from_utc_timestamp*
fullHostName*
fuzzBits
gccMurmurHash
gcd
generateRandomStructure
generateSerialID
generateSnowflakeID
generateULID
generateUUIDv4
generateUUIDv7
generateUUIDv7NonMonotonic
generateUUIDv7ThreadMonotonic
geoDistance
geoToH3
geoToS2
geohashDecode
geohashEncode
geohashesInBox
getClientHTTPHeader
getMacro
getMaxTableNameLengthForDatabase
getOSKernelVersion
getServerPort
getSetting
getSettingOrDefault
getSizeOfEnumType
getSubcolumn
getTypeSerializationStreams
globalIn
globalInIgnoreSet
globalNotIn
globalNotInIgnoreSet
globalNotNullIn
globalNotNullInIgnoreSet
globalNullIn
globalNullInIgnoreSet
globalVariable
greatCircleAngle
greatCircleDistance
greater
greaterOrEquals
greatest
groupArray
groupArrayInsertAt
groupArrayIntersect
groupArrayLast
groupArrayMovingAvg
groupArrayMovingSum
groupArraySample
groupArraySorted
groupBitAnd
groupBitOr
groupBitXor
groupBitmap
groupBitmapAnd
groupBitmapOr
groupBitmapXor
groupConcat
groupUniqArray
group_concat*
h3CellAreaM2
h3CellAreaRads2
h3DegsToRads
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
h3Line
h3NumHexagons
h3PointDistKm
h3PointDistM
h3PointDistRads
h3RadsToDegs
h3ToCenterChild
h3ToChildren
h3ToGeo
h3ToGeoBoundary
h3ToParent
h3ToString
h3UnidirectionalEdgeIsValid
h3kRing
halfMD5
has
hasAll
hasAny
hasColumnInTable
hasSubsequence
hasSubsequenceCaseInsensitive
hasSubsequenceCaseInsensitiveUTF8
hasSubsequenceUTF8
hasSubstr
hasThreadFuzzer
hasToken
hasTokenCaseInsensitive
hasTokenCaseInsensitiveOrNull
hasTokenOrNull
hashid
hex
hilbertDecode
hilbertEncode
histogram
hiveHash
hop
hopEnd
hopStart
hostName
hostname*
hypot
identity
idnaDecode
idnaEncode
if
ifNotFinite
ifNull
ignore
ilike
in
inIgnoreSet
indexHint
indexOf
indexOfAssumeSorted
initcap
initcapUTF8
initialQueryID
initialQueryStartTime
initial_query_id*
initial_query_start_time*
initializeAggregation
instr*
intDiv
intDivOrZero
intExp10
intExp2
intHash32
intHash64
intervalLengthSum
isConstant
isDecimalOverflow
isDynamicElementInSharedData
isFinite
isIPAddressInRange
isIPv4String
isIPv6String
isInfinite
isNaN
isNotDistinctFrom
isNotNull
isNull
isNullable
isValidJSON
isValidUTF8
isZeroOrNull
jaroSimilarity
jaroWinklerSimilarity
javaHash
javaHashUTF16LE
joinGet
joinGetOrNull
jsonMergePatch*
jumpConsistentHash
kafkaMurmurHash
kolmogorovSmirnovTest
kostikConsistentHash
kql_array_sort_asc
kql_array_sort_desc
kurtPop
kurtSamp
lagInFrame
largestTriangleThreeBuckets
lastValueRespectNulls*
last_value*
last_value_respect_nulls*
lcase*
lcm
leadInFrame
least
left
leftPad
leftPadUTF8
leftUTF8
lemmatize
length
lengthUTF8
less
lessOrEquals
levenshteinDistance*
levenshteinDistanceUTF8*
lgamma
like
ln*
locate*
log
log10
log1p
log2
logTrace
lowCardinalityIndices
lowCardinalityKeys
lower
lowerUTF8
lpad*
ltrim*
lttb*
makeDate
makeDate32
makeDateTime
makeDateTime64
mannWhitneyUTest
map
mapAdd
mapAll
mapApply
mapConcat
mapContains
mapContainsKeyLike
mapExists
mapExtractKeyLike
mapFilter
mapFromArrays
mapFromString*
mapKeys
mapPartialReverseSort
mapPartialSort
mapPopulateSeries
mapReverseSort
mapSort
mapSubtract
mapUpdate
mapValues
match
materialize
max
max2
maxIntersections
maxIntersectionsPosition
maxMap
maxMappedArrays
meanZTest
median*
medianBFloat16*
medianBFloat16Weighted*
medianDD*
medianDeterministic*
medianExact*
medianExactHigh*
medianExactLow*
medianExactWeighted*
medianExactWeightedInterpolated*
medianGK*
medianInterpolatedWeighted*
medianTDigest*
medianTDigestWeighted*
medianTiming*
medianTimingWeighted*
meiliMatch
metroHash64
mid*
min
min2
minMap
minMappedArrays
minSampleSizeContinous*
minSampleSizeContinuous
minSampleSizeConversion
minus
mismatches*
mod*
modelEvaluate
modulo
moduloLegacy
moduloOrZero
monthName
mortonDecode
mortonEncode
multiFuzzyMatchAllIndices
multiFuzzyMatchAny
multiFuzzyMatchAnyIndex
multiIf
multiMatchAllIndices
multiMatchAny
multiMatchAnyIndex
multiSearchAllPositions
multiSearchAllPositionsCaseInsensitive
multiSearchAllPositionsCaseInsensitiveUTF8
multiSearchAllPositionsUTF8
multiSearchAny
multiSearchAnyCaseInsensitive
multiSearchAnyCaseInsensitiveUTF8
multiSearchAnyUTF8
multiSearchFirstIndex
multiSearchFirstIndexCaseInsensitive
multiSearchFirstIndexCaseInsensitiveUTF8
multiSearchFirstIndexUTF8
multiSearchFirstPosition
multiSearchFirstPositionCaseInsensitive
multiSearchFirstPositionCaseInsensitiveUTF8
multiSearchFirstPositionUTF8
multiply
multiplyDecimal
murmurHash2_32
murmurHash2_64
murmurHash3_128
murmurHash3_32
murmurHash3_64
negate
neighbor
nested
netloc
ngramDistance
ngramDistanceCaseInsensitive
ngramDistanceCaseInsensitiveUTF8
ngramDistanceUTF8
ngramMinHash
ngramMinHashArg
ngramMinHashArgCaseInsensitive
ngramMinHashArgCaseInsensitiveUTF8
ngramMinHashArgUTF8
ngramMinHashCaseInsensitive
ngramMinHashCaseInsensitiveUTF8
ngramMinHashUTF8
ngramSearch
ngramSearchCaseInsensitive
ngramSearchCaseInsensitiveUTF8
ngramSearchUTF8
ngramSimHash
ngramSimHashCaseInsensitive
ngramSimHashCaseInsensitiveUTF8
ngramSimHashUTF8
ngrams
nonNegativeDerivative
normL1*
normL2*
normL2Squared*
normLinf*
normLp*
normalizeL1*
normalizeL2*
normalizeLinf*
normalizeLp*
normalizeQuery
normalizeQueryKeepNames
normalizeUTF8NFC
normalizeUTF8NFD
normalizeUTF8NFKC
normalizeUTF8NFKD
normalizedQueryHash
normalizedQueryHashKeepNames
not
notEmpty
notEquals
notILike
notIn
notInIgnoreSet
notLike
notNullIn
notNullInIgnoreSet
nothing
nothingNull
nothingUInt64
now
now64
nowInBlock
nth_value
ntile
nullIf
nullIn
nullInIgnoreSet
or
overlay
overlayUTF8
parseDateTime
parseDateTime32BestEffort
parseDateTime32BestEffortOrNull
parseDateTime32BestEffortOrZero
parseDateTime64
parseDateTime64BestEffort
parseDateTime64BestEffortOrNull
parseDateTime64BestEffortOrZero
parseDateTime64BestEffortUS
parseDateTime64BestEffortUSOrNull
parseDateTime64BestEffortUSOrZero
parseDateTime64InJodaSyntax
parseDateTime64InJodaSyntaxOrNull
parseDateTime64InJodaSyntaxOrZero
parseDateTime64OrNull
parseDateTime64OrZero
parseDateTimeBestEffort
parseDateTimeBestEffortOrNull
parseDateTimeBestEffortOrZero
parseDateTimeBestEffortUS
parseDateTimeBestEffortUSOrNull
parseDateTimeBestEffortUSOrZero
parseDateTimeInJodaSyntax
parseDateTimeInJodaSyntaxOrNull
parseDateTimeInJodaSyntaxOrZero
parseDateTimeOrNull
parseDateTimeOrZero
parseReadableSize
parseReadableSizeOrNull
parseReadableSizeOrZero
parseTimeDelta
partitionID*
partitionId
path
pathFull
percentRank
percent_rank*
pi
plus
pmod*
pointInEllipses
pointInPolygon
polygonAreaCartesian
polygonAreaSpherical
polygonConvexHullCartesian
polygonPerimeterCartesian
polygonPerimeterSpherical
polygonsDistanceCartesian
polygonsDistanceSpherical
polygonsEqualsCartesian
polygonsIntersectionCartesian
polygonsIntersectionSpherical
polygonsSymDifferenceCartesian
polygonsSymDifferenceSpherical
polygonsUnionCartesian
polygonsUnionSpherical
polygonsWithinCartesian
polygonsWithinSpherical
port
portRFC
position
positionCaseInsensitive
positionCaseInsensitiveUTF8
positionUTF8
positiveModulo
positive_modulo*
pow
power*
printf
proportionsZTest
protocol
punycodeDecode
punycodeEncode
quantile
quantileBFloat16
quantileBFloat16Weighted
quantileDD
quantileDeterministic
quantileExact
quantileExactExclusive
quantileExactHigh
quantileExactInclusive
quantileExactLow
quantileExactWeighted
quantileExactWeightedInterpolated
quantileGK
quantileInterpolatedWeighted
quantileTDigest
quantileTDigestWeighted
quantileTiming
quantileTimingWeighted
quantiles
quantilesBFloat16
quantilesBFloat16Weighted
quantilesDD
quantilesDeterministic
quantilesExact
quantilesExactExclusive
quantilesExactHigh
quantilesExactInclusive
quantilesExactLow
quantilesExactWeighted
quantilesExactWeightedInterpolated
quantilesGK
quantilesInterpolatedWeighted
quantilesTDigest
quantilesTDigestWeighted
quantilesTiming
quantilesTimingWeighted
queryID
queryString
queryStringAndFragment
query_id*
radians
rand
rand32*
rand64
randBernoulli
randBinomial
randCanonical
randChiSquared
randConstant
randExponential
randFisherF
randLogNormal
randNegativeBinomial
randNormal
randPoisson
randStudentT
randUniform
randomFixedString
randomPrintableASCII
randomString
randomStringUTF8
range
rank
rankCorr
readWKTLineString
readWKTMultiLineString
readWKTMultiPolygon
readWKTPoint
readWKTPolygon
readWKTRing
readWktMultiPolygon
readWktPoint
readWktPolygon
readWktRing
regexpExtract
regexpQuoteMeta
regionHierarchy
regionIn
regionToArea
regionToCity
regionToContinent
regionToCountry
regionToDistrict
regionToName
regionToPopulation
regionToTopContinent
reinterpret
reinterpretAsDate
reinterpretAsDateTime
reinterpretAsFixedString
reinterpretAsFloat32
reinterpretAsFloat64
reinterpretAsInt128
reinterpretAsInt16
reinterpretAsInt256
reinterpretAsInt32
reinterpretAsInt64
reinterpretAsInt8
reinterpretAsString
reinterpretAsUInt128
reinterpretAsUInt16
reinterpretAsUInt256
reinterpretAsUInt32
reinterpretAsUInt64
reinterpretAsUInt8
reinterpretAsUUID
repeat
replace*
replaceAll
replaceOne
replaceRegexpAll
replaceRegexpOne
replicate
retention
reverse
reverseDNSQuery
reverseUTF8
revision
right
rightPad
rightPadUTF8
rightUTF8
round
roundAge
roundBankers
roundDown
roundDuration
roundToExp2
rowNumberInAllBlocks
rowNumberInBlock
row_number
rpad*
rtrim*
runningAccumulate
runningConcurrency
runningDifference
runningDifferenceStartingWithFirstValue
s2CapContains
s2CapUnion
s2CellsIntersect
s2GetNeighbors
s2RectAdd
s2RectContains
s2RectIntersection
s2RectUnion
s2ToGeo
scalarProduct*
sequenceCount
sequenceMatch
sequenceMatchEvents
sequenceNextNode
seriesDecomposeSTL
seriesOutliersDetectTukey
seriesPeriodDetectFFT
serverTimeZone*
serverTimezone
serverUUID
shardCount
shardNum
showCertificate
sigmoid
sign
simpleJSONExtractBool
simpleJSONExtractFloat
simpleJSONExtractInt
simpleJSONExtractRaw
simpleJSONExtractString
simpleJSONExtractUInt
simpleJSONHas
simpleLinearRegression
sin
singleValueOrNull
sinh
sipHash128
sipHash128Keyed
sipHash128Reference
sipHash128ReferenceKeyed
sipHash64
sipHash64Keyed
skewPop
skewSamp
sleep
sleepEachRow
snowflakeIDToDateTime
snowflakeIDToDateTime64
snowflakeToDateTime
snowflakeToDateTime64
soundex
space
sparkBar*
sparkbar
splitByAlpha*
splitByChar
splitByNonAlpha
splitByRegexp
splitByString
splitByWhitespace
sqid*
sqidDecode
sqidEncode
sqrt
startsWith
startsWithUTF8
stddevPop
stddevPopStable
stddevSamp
stddevSampStable
stem
stochasticLinearRegression
stochasticLogisticRegression
str_to_date*
str_to_map*
stringJaccardIndex
stringJaccardIndexUTF8
stringToH3
structureToCapnProtoSchema
structureToProtobufSchema
studentTTest
subBitmap
subDate
substr*
substring
substringIndex
substringIndexUTF8
substringUTF8
subtractDays
subtractHours
subtractInterval
subtractMicroseconds
subtractMilliseconds
subtractMinutes
subtractMonths
subtractNanoseconds
subtractQuarters
subtractSeconds
subtractTupleOfIntervals
subtractWeeks
subtractYears
sum
sumCount
sumKahan
sumMap
sumMapFiltered
sumMapFilteredWithOverflow
sumMapWithOverflow
sumMappedArrays
sumWithOverflow
svg
synonyms
tan
tanh
tcpPort
tgamma
theilsU
throwIf
tid
timeDiff
timeSlot
timeSlots
timeZone*
timeZoneOf*
timeZoneOffset*
time_bucket*
timestamp
timestampDiff*
timestamp_diff*
timezone
timezoneOf
timezoneOffset
toBFloat16
toBFloat16OrNull
toBFloat16OrZero
toBool
toColumnTypeName
toDate
toDate32
toDate32OrDefault
toDate32OrNull
toDate32OrZero
toDateOrDefault
toDateOrNull
toDateOrZero
toDateTime
toDateTime32
toDateTime64
toDateTime64OrDefault
toDateTime64OrNull
toDateTime64OrZero
toDateTimeOrDefault
toDateTimeOrNull
toDateTimeOrZero
toDayOfMonth
toDayOfWeek
toDayOfYear
toDaysSinceYearZero
toDecimal128
toDecimal128OrDefault
toDecimal128OrNull
toDecimal128OrZero
toDecimal256
toDecimal256OrDefault
toDecimal256OrNull
toDecimal256OrZero
toDecimal32
toDecimal32OrDefault
toDecimal32OrNull
toDecimal32OrZero
toDecimal64
toDecimal64OrDefault
toDecimal64OrNull
toDecimal64OrZero
toDecimalString
toFixedString
toFloat32
toFloat32OrDefault
toFloat32OrNull
toFloat32OrZero
toFloat64
toFloat64OrDefault
toFloat64OrNull
toFloat64OrZero
toHour
toIPv4
toIPv4OrDefault
toIPv4OrNull
toIPv4OrZero
toIPv6
toIPv6OrDefault
toIPv6OrNull
toIPv6OrZero
toISOWeek
toISOYear
toInt128
toInt128OrDefault
toInt128OrNull
toInt128OrZero
toInt16
toInt16OrDefault
toInt16OrNull
toInt16OrZero
toInt256
toInt256OrDefault
toInt256OrNull
toInt256OrZero
toInt32
toInt32OrDefault
toInt32OrNull
toInt32OrZero
toInt64
toInt64OrDefault
toInt64OrNull
toInt64OrZero
toInt8
toInt8OrDefault
toInt8OrNull
toInt8OrZero
toIntervalDay
toIntervalHour
toIntervalMicrosecond
toIntervalMillisecond
toIntervalMinute
toIntervalMonth
toIntervalNanosecond
toIntervalQuarter
toIntervalSecond
toIntervalWeek
toIntervalYear
toJSONString
toLastDayOfMonth
toLastDayOfWeek
toLowCardinality
toMillisecond
toMinute
toModifiedJulianDay
toModifiedJulianDayOrNull
toMonday
toMonth
toNullable
toQuarter
toRelativeDayNum
toRelativeHourNum
toRelativeMinuteNum
toRelativeMonthNum
toRelativeQuarterNum
toRelativeSecondNum
toRelativeWeekNum
toRelativeYearNum
toSecond
toStartOfDay
toStartOfFifteenMinutes
toStartOfFiveMinute*
toStartOfFiveMinutes
toStartOfHour
toStartOfISOYear
toStartOfInterval
toStartOfMicrosecond
toStartOfMillisecond
toStartOfMinute
toStartOfMonth
toStartOfNanosecond
toStartOfQuarter
toStartOfSecond
toStartOfTenMinutes
toStartOfWeek
toStartOfYear
toString
toStringCutToZero
toTime
toTimeZone*
toTimezone
toTypeName
toUInt128
toUInt128OrDefault
toUInt128OrNull
toUInt128OrZero
toUInt16
toUInt16OrDefault
toUInt16OrNull
toUInt16OrZero
toUInt256
toUInt256OrDefault
toUInt256OrNull
toUInt256OrZero
toUInt32
toUInt32OrDefault
toUInt32OrNull
toUInt32OrZero
toUInt64
toUInt64OrDefault
toUInt64OrNull
toUInt64OrZero
toUInt8
toUInt8OrDefault
toUInt8OrNull
toUInt8OrZero
toUTCTimestamp
toUUID
toUUIDOrDefault
toUUIDOrNull
toUUIDOrZero
toUnixTimestamp
toUnixTimestamp64Micro
toUnixTimestamp64Milli
toUnixTimestamp64Nano
toUnixTimestamp64Second
toValidUTF8
toWeek
toYYYYMM
toYYYYMMDD
toYYYYMMDDhhmmss
toYear
toYearWeek
to_utc_timestamp*
today
tokens
topK
topKWeighted
topLevelDomain
topLevelDomainRFC
transactionID
transactionLatestSnapshot
transactionOldestSnapshot
transform
translate
translateUTF8
trim*
trimBoth
trimLeft
trimRight
trunc
truncate*
tryBase58Decode
tryBase64Decode
tryBase64URLDecode
tryDecrypt
tryIdnaEncode
tryPunycodeDecode
tumble
tumbleEnd
tumbleStart
tuple
tupleConcat
tupleDivide
tupleDivideByNumber
tupleElement
tupleHammingDistance
tupleIntDiv
tupleIntDivByNumber
tupleIntDivOrZero
tupleIntDivOrZeroByNumber
tupleMinus
tupleModulo
tupleModuloByNumber
tupleMultiply
tupleMultiplyByNumber
tupleNames
tupleNegate
tuplePlus
tupleToNameValuePairs
ucase*
unbin
unhex
uniq
uniqCombined
uniqCombined64
uniqExact
uniqHLL12
uniqTheta
uniqThetaIntersect
uniqThetaNot
uniqThetaUnion
uniqUpTo
upper
upperUTF8
uptime
user*
validateNestedArraySizes
varPop
varPopStable
varSamp
varSampStable
variantElement
variantType
vectorDifference*
vectorSum*
version
visibleWidth
visitParamExtractBool*
visitParamExtractFloat*
visitParamExtractInt*
visitParamExtractRaw*
visitParamExtractString*
visitParamExtractUInt*
visitParamHas*
week*
welchTTest
widthBucket
width_bucket*
windowFunnel
windowID
wkt
wordShingleMinHash
wordShingleMinHashArg
wordShingleMinHashArgCaseInsensitive
wordShingleMinHashArgCaseInsensitiveUTF8
wordShingleMinHashArgUTF8
wordShingleMinHashCaseInsensitive
wordShingleMinHashCaseInsensitiveUTF8
wordShingleMinHashUTF8
wordShingleSimHash
wordShingleSimHashCaseInsensitive
wordShingleSimHashCaseInsensitiveUTF8
wordShingleSimHashUTF8
wyHash64
xor
xxHash32
xxHash64
xxh3
yandexConsistentHash*
yearweek*
yesterday
zookeeperSessionUptime

* indicates an alias to another function