Поддержка функций

Ниже приведена информация о поддержке функций различными источниками.

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)
Вычитание (-)XXXXXXXXXX
Деление (/)XXXXXXXXXX
Остаток (%)XXXXXXXXX
Отрицание (-)XXXXXXXXX
Сложение и конкатенация (+)XXXXXXXXXX
СравнениеXXXXXXXXXX
Степень (^)XXXXXXXXX
Умножение (*)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 (оконная)XXXXXXXX
AVG_IFXXXXXXXXX
AVG_IF (оконная)XXXXXXXX
BETWEENXXXXXXXXXX
BOLDXXXXXXXXX
BOOLXXXXXXXXX
CASEXXXXXXXXX
CAST_ARR_FLOATXXXX
CAST_ARR_INTXXXX
CAST_ARR_STRXXXX
CEILINGXXXXXXXXX
CHARXXXXXXXXX
COMPAREXX
CONCATXXXXXXXXX
CONTAINS (массивы)XXXX
CONTAINS (строковая)XXXXXXXXXX
CONTAINS_ALLXXXX
CONTAINS_ANYXXXX
CONTAINS_SUBSEQUENCEXX
COSXXXXXXXXX
COTXXXXXXXXX
COUNTXXXXXXXXX
COUNT (оконная)XXXXXXXX
COUNTDXXXXXXXXX
COUNTD_APPROXXXXX
COUNTD_IFXXXXXXXXX
COUNT_IFXXXXXXXXX
COUNT_IF (оконная)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 (оконная)XXXXXXXX
FLOATXXXXXXXXX
FLOORXXXXXXXXX
GEOPOINTXXXXXXXXX
GEOPOLYGONXXXXXXXXX
GET_ITEMXXXX
GREATESTXXXXXXXXX
HOURXXXXXXXXX
ICONTAINSXXXXXXXXX
IENDSWITHXXXXXXXXX
IFXXXXXXXXX
IFNULLXXXXXXXXX
INXXXXXXXXXX
INTXXXXXXXXX
IS FALSEXXXXXXXXX
IS TRUEXXXXXXXXX
ISNULLXXXXXXXXX
ISTARTSWITHXXXXXXXXX
ITALICXXXXXXXXX
LAG (оконная)XXXXXXXX
LAST (оконная)XXXXXXXX
LEASTXXXXXXXXX
LEFTXXXXXXXXX
LENXXXXXXXXX
LIKEXXXXXXXXX
LNXXXXXXXXX
LOGXXXXXXXXX
LOG10XXXXXXXXX
LOWERXXXXXXXXX
LTRIMXXXXXXXX
MARKUPXXXXXXXXX
MAVG (оконная)XXXXXXXX
MAXXXXXXXXXX
MAX (оконная)XXXXXXXX
MCOUNT (оконная)XXXXXXXX
MEDIANXXXXX
MINXXXXXXXXX
MIN (оконная)XXXXXXXX
MINUTEXXXXXXXXX
MMAX (оконная)XXXXXXXX
MMIN (оконная)XXXXXXXX
MONTHXXXXXXXXX
MSUM (оконная)XXXXXXXX
NOTXXXXXXXXXX
NOWXXXXXXXXX
ORXXXXXXXXXX
PIXXXXXXXXX
POWERXXXXXXXXX
QUANTILEXXXXX
QUANTILE_APPROXXX
QUARTERXXXXXXXXX
RADIANSXXXXXXXXX
RANK (оконная)XXXXXXXX
RANK_DENSE (оконная)XXXXXXXX
RANK_PERCENTILE (оконная)XXXXXXXX
RANK_UNIQUE (оконная)XXXXXXXX
RAVG (оконная)XXXXXXXX
RCOUNT (оконная)XXXXXXXX
REGEXP_EXTRACTXXXXXX
REGEXP_EXTRACT_NTHXXXXXX
REGEXP_MATCHXXXXXXX
REGEXP_REPLACEXXXXXX
REPLACE (массивы)XXXX
REPLACE (строковая)XXXXXXXXX
RIGHTXXXXXXXXX
RMAX (оконная)XXXXXXXX
RMIN (оконная)XXXXXXXX
ROUNDXXXXXXXXX
RSUM (оконная)XXXXXXXX
RTRIMXXXXXXXX
SECONDXXXXXXXXX
SIGNXXXXXXXXX
SINXXXXXXXXX
SLICEXXXX
SPACEXXXXXXXXX
SPLITXXXXXXX
SQRTXXXXXXXXX
SQUAREXXXXXXXXX
STARTSWITH (массивы)XXXX
STARTSWITH (строковая)XXXXXXXXXX
STDEVXXXXXXXXX
STDEVPXXXXXXXXX
STRXXXXXXXXX
SUBSTRXXXXXXXXX
SUMXXXXXXXXX
SUM (оконная)XXXXXXXX
SUM_IFXXXXXXXXX
SUM_IF (оконная)XXXXXXXX
TANXXXXXXXXX
TODAYXXXXXXXXX
TOP_CONCATXXX
TRIMXXXXXXXX
UNNESTXXXX
UPPERXXXXXXXXX
URLXXXXXXXXX
UTF8XX
VARXXXXXXXXX
VARPXXXXXXXXX
WEEKXXXXXXXXX
YEARXXXXXXXXX
ZNXXXXXXXXX