Function Availability

Function availability for various data source types.

FunctionClickHouse
21.8
ClickHouse
22.10
Yandex MetricaMicrosoft
SQL Server 2017
(14.0)
MySQL
5.7
MySQL
8.0.12
Oracle
Database 12c
(12.1)
PostgreSQL
9.3
PostgreSQL
9.4
YDB
(YQL)
Addition and concatenation (+)XXXXXXXXXX
ComparisonXXXXXXXXXX
Division (/)XXXXXXXXXX
Modulo (%)XXXXXXXXX
Multiplication (*)XXXXXXXXXX
Negation (-)XXXXXXXXX
Power (^)XXXXXXXXX
Subtraction (-)XXXXXXXXXX
ABSXXXXXXXXX
ACOSXXXXXXXXX
AGOXXXXXXXXXX
ALL_CONCATXXXXX
ANDXXXXXXXXXX
ANYXXXXX
ARG_MAXXXX
ARG_MINXXX
ARRAYXXXX
ARR_AVGXX
ARR_MAXXX
ARR_MINXX
ARR_PRODUCTXX
ARR_REMOVEXXXX
ARR_STRXXXX
ARR_SUMXX
ASCIIXXXXXXXXX
ASINXXXXXXXXX
ATANXXXXXXXXX
ATAN2XXXXXXXXX
AT_DATEXXXXXXXXXX
AVGXXXXXXXXX
AVG (window)XXXXXXXX
AVG_IFXXXXXXXXX
AVG_IF (window)XXXXXXXX
BETWEENXXXXXXXXXX
BOLDXXXXXXXXX
BOOLXXXXXXXXX
CASEXXXXXXXXX
CAST_ARR_FLOATXXXX
CAST_ARR_INTXXXX
CAST_ARR_STRXXXX
CEILINGXXXXXXXXX
CHARXXXXXXXXX
COMPAREXX
CONCATXXXXXXXXX
CONTAINS (array)XXXX
CONTAINS (string)XXXXXXXXXX
CONTAINS_ALLXXXX
CONTAINS_ANYXXXX
CONTAINS_SUBSEQUENCEXX
COSXXXXXXXXX
COTXXXXXXXXX
COUNTXXXXXXXXX
COUNT (window)XXXXXXXX
COUNTDXXXXXXXXX
COUNTD_APPROXXXXX
COUNTD_IFXXXXXXXXX
COUNT_IFXXXXXXXXX
COUNT_IF (window)XXXXXXXX
COUNT_ITEMXXXX
DATEXXXXXXXXX
DATEADDXXXXXXXXXX
DATEPARTXXXXXXXXX
DATETIMEXXXXXXXXXX
DATETIME_PARSEXX
DATETRUNCXXXXXXXXX
DATE_PARSEXX
DAYXXXXXXXXX
DAYOFWEEKXXXXXXXXX
DB_CASTXXXX
DEGREESXXXXXXXXX
DIVXXXXXXXXX
DIV_SAFEXXXXXXXXX
ENDSWITHXXXXXXXXXX
EXPXXXXXXXXX
FDIV_SAFEXXXXXXXXX
FINDXXXXXXXXX
FIRST (window)XXXXXXXX
FLOATXXXXXXXXX
FLOORXXXXXXXXX
GEOPOINTXXXXXXXXX
GEOPOLYGONXXXXXXXXX
GET_ITEMXXXX
GREATESTXXXXXXXXX
HOURXXXXXXXXX
ICONTAINSXXXXXXXXX
IENDSWITHXXXXXXXXX
IFXXXXXXXXX
IFNULLXXXXXXXXX
INXXXXXXXXXX
INTXXXXXXXXX
IS FALSEXXXXXXXXX
IS TRUEXXXXXXXXX
ISNULLXXXXXXXXX
ISTARTSWITHXXXXXXXXX
ITALICXXXXXXXXX
LAG (window)XXXXXXXX
LAST (window)XXXXXXXX
LEASTXXXXXXXXX
LEFTXXXXXXXXX
LENXXXXXXXXX
LIKEXXXXXXXXX
LNXXXXXXXXX
LOGXXXXXXXXX
LOG10XXXXXXXXX
LOWERXXXXXXXXX
LTRIMXXXXXXXX
MARKUPXXXXXXXXX
MAVG (window)XXXXXXXX
MAXXXXXXXXXX
MAX (window)XXXXXXXX
MCOUNT (window)XXXXXXXX
MEDIANXXXXX
MINXXXXXXXXX
MIN (window)XXXXXXXX
MINUTEXXXXXXXXX
MMAX (window)XXXXXXXX
MMIN (window)XXXXXXXX
MONTHXXXXXXXXX
MSUM (window)XXXXXXXX
NOTXXXXXXXXXX
NOWXXXXXXXXX
ORXXXXXXXXXX
PIXXXXXXXXX
POWERXXXXXXXXX
QUANTILEXXXXX
QUANTILE_APPROXXX
QUARTERXXXXXXXXX
RADIANSXXXXXXXXX
RANK (window)XXXXXXXX
RANK_DENSE (window)XXXXXXXX
RANK_PERCENTILE (window)XXXXXXXX
RANK_UNIQUE (window)XXXXXXXX
RAVG (window)XXXXXXXX
RCOUNT (window)XXXXXXXX
REGEXP_EXTRACTXXXXXX
REGEXP_EXTRACT_NTHXXXXXX
REGEXP_MATCHXXXXXXX
REGEXP_REPLACEXXXXXX
REPLACE (array)XXXX
REPLACE (string)XXXXXXXXX
RIGHTXXXXXXXXX
RMAX (window)XXXXXXXX
RMIN (window)XXXXXXXX
ROUNDXXXXXXXXX
RSUM (window)XXXXXXXX
RTRIMXXXXXXXX
SECONDXXXXXXXXX
SIGNXXXXXXXXX
SINXXXXXXXXX
SLICEXXXX
SPACEXXXXXXXXX
SPLITXXXXXXX
SQRTXXXXXXXXX
SQUAREXXXXXXXXX
STARTSWITH (array)XXXX
STARTSWITH (string)XXXXXXXXXX
STDEVXXXXXXXXX
STDEVPXXXXXXXXX
STRXXXXXXXXX
SUBSTRXXXXXXXXX
SUMXXXXXXXXX
SUM (window)XXXXXXXX
SUM_IFXXXXXXXXX
SUM_IF (window)XXXXXXXX
TANXXXXXXXXX
TODAYXXXXXXXXX
TOP_CONCATXXX
TRIMXXXXXXXX
UNNESTXXXX
UPPERXXXXXXXXX
URLXXXXXXXXX
UTF8XX
VARXXXXXXXXX
VARPXXXXXXXXX
WEEKXXXXXXXXX
YEARXXXXXXXXX
ZNXXXXXXXXX