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

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

Function ClickHouse
21.8		 ClickHouse
22.10		 Файлы Google Sheets Yandex Metrica Microsoft
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)
Вычитание (-) X X X X X X X X X X X X X
Деление (/) X X X X X X X X X X X X X
Остаток (%) X X X X X X X X X X X X
Отрицание (-) X X X X X X X X X X X X
Сложение и конкатенация (+) X X X X X X X X X X X X X
Сравнение X X X X X X X X X X X X X
Степень (^) X X X X X X X X X X X X
Умножение (*) X X X X X X X X X X X X X
ABS X X X X X X X X X X X X
ACOS X X X X X X X X X X X X
AGO X X X X X X X X X X X X X
ALL_CONCAT X X X X X X X X
AND X X X X X X X X X X X X X
ANY X X X X X X X X
ARG_MAX X X X X X X
ARG_MIN X X X X X X
ARRAY X X X X X X X
ARR_AVG X X X X X
ARR_INTERSECT X X X X X X X
ARR_MAX X X X X X
ARR_MIN X X X X X
ARR_PRODUCT X X X X X
ARR_REMOVE X X X X X X X
ARR_STR X X X X X X X
ARR_SUM X X X X X
ASCII X X X X X X X X X X X X
ASIN X X X X X X X X X X X X
ATAN X X X X X X X X X X X X
ATAN2 X X X X X X X X X X X X
AT_DATE X X X X X X X X X X X X X
AVG X X X X X X X X X X X X
AVG (оконная) X X X X X X X X X X X
AVG_IF X X X X X X X X X X X X
AVG_IF (оконная) X X X X X X X X X X X
BETWEEN X X X X X X X X X X X X X
BOLD X X X X X X X X X X X X
BOOL X X X X X X X X X X X X
BR X X X X X X X X X X X X
CASE X X X X X X X X X X X X
CAST_ARR_FLOAT X X X X X X X
CAST_ARR_INT X X X X X X X
CAST_ARR_STR X X X X X X X
CEILING X X X X X X X X X X X X
CHAR X X X X X X X X X X X X
COLOR X X X X X X X X X X X X
COMPARE X X X X X
CONCAT X X X X X X X X X X X X
CONTAINS (массивы) X X X X X X X
CONTAINS (строковая) X X X X X X X X X X X X X
CONTAINS_ALL X X X X X X X
CONTAINS_ANY X X X X X X X
CONTAINS_SUBSEQUENCE X X X X X
COS X X X X X X X X X X X X
COT X X X X X X X X X X X X
COUNT X X X X X X X X X X X X
COUNT (оконная) X X X X X X X X X X X
COUNTD X X X X X X X X X X X X
COUNTD_APPROX X X X X X X X
COUNTD_IF X X X X X X X X X X X X
COUNT_IF X X X X X X X X X X X X
COUNT_IF (оконная) X X X X X X X X X X X
COUNT_ITEM X X X X X X X
DATE X X X X X X X X X X X X
DATEADD X X X X X X X X X X X X X
DATEPART X X X X X X X X X X X X
DATETIME X X X X X X X X X X X X X
DATETIME_PARSE X X X X X
DATETRUNC X X X X X X X X X X X X
DATE_PARSE X X X X X
DAY X X X X X X X X X X X X
DAYOFWEEK X X X X X X X X X X X X
DB_CAST X X X X X X X
DEGREES X X X X X X X X X X X X
DIV X X X X X X X X X X X X
DIV_SAFE X X X X X X X X X X X X
ENDSWITH X X X X X X X X X X X X X
EXP X X X X X X X X X X X X
FDIV_SAFE X X X X X X X X X X X X
FIND X X X X X X X X X X X X
FIRST (оконная) X X X X X X X X X X X
FLOAT X X X X X X X X X X X X
FLOOR X X X X X X X X X X X X
GEOPOINT X X X X X X X X X X X X
GEOPOLYGON X X X X X X X X X X X X
GET_ITEM X X X X X X X
GREATEST X X X X X X X X X X X X
HOUR X X X X X X X X X X X X
ICONTAINS X X X X X X X X X X X X
IENDSWITH X X X X X X X X X X X X
IF X X X X X X X X X X X X
IFNULL X X X X X X X X X X X X
IMAGE X X X X X X X X X X X X
IN X X X X X X X X X X X X X
INT X X X X X X X X X X X X
IS FALSE X X X X X X X X X X X X
IS TRUE X X X X X X X X X X X X
ISNULL X X X X X X X X X X X X
ISTARTSWITH X X X X X X X X X X X X
ITALIC X X X X X X X X X X X X
LAG (оконная) X X X X X X X X X X X
LAST (оконная) X X X X X X X X X X X
LEAST X X X X X X X X X X X X
LEFT X X X X X X X X X X X X
LEN (массивы) X X X X X X X
LEN X X X X X X X X X X X X
LIKE X X X X X X X X X X X X
LN X X X X X X X X X X X X
LOG X X X X X X X X X X X X
LOG10 X X X X X X X X X X X X
LOWER X X X X X X X X X X X X
LTRIM X X X X X X X X X X X
MARKUP X X X X X X X X X X X X
MAVG (оконная) X X X X X X X X X X X
MAX X X X X X X X X X X X X
MAX (оконная) X X X X X X X X X X X
MCOUNT (оконная) X X X X X X X X X X X
MEDIAN X X X X X X X X
MIN X X X X X X X X X X X X
MIN (оконная) X X X X X X X X X X X
MINUTE X X X X X X X X X X X X
MMAX (оконная) X X X X X X X X X X X
MMIN (оконная) X X X X X X X X X X X
MONTH X X X X X X X X X X X X
MSUM (оконная) X X X X X X X X X X X
NOT X X X X X X X X X X X X X
NOW X X X X X X X X X X X X
OR X X X X X X X X X X X X X
PI X X X X X X X X X X X X
POWER X X X X X X X X X X X X
QUANTILE X X X X X X X X
QUANTILE_APPROX X X X X X
QUARTER X X X X X X X X X X X X
RADIANS X X X X X X X X X X X X
RANK (оконная) X X X X X X X X X X X
RANK_DENSE (оконная) X X X X X X X X X X X
RANK_PERCENTILE (оконная) X X X X X X X X X X X
RANK_UNIQUE (оконная) X X X X X X X X X X X
RAVG (оконная) X X X X X X X X X X X
RCOUNT (оконная) X X X X X X X X X X X
REGEXP_EXTRACT X X X X X X X X X
REGEXP_EXTRACT_ALL X X X X X X X
REGEXP_EXTRACT_NTH X X X X X X X X X
REGEXP_MATCH X X X X X X X X X X
REGEXP_REPLACE X X X X X X X X X
REPLACE (массивы) X X X X X X X
REPLACE (строковая) X X X X X X X X X X X X
RIGHT X X X X X X X X X X X X
RMAX (оконная) X X X X X X X X X X X
RMIN (оконная) X X X X X X X X X X X
ROUND X X X X X X X X X X X X
RSUM (оконная) X X X X X X X X X X X
RTRIM X X X X X X X X X X X
SECOND X X X X X X X X X X X X
SIGN X X X X X X X X X X X X
SIN X X X X X X X X X X X X
SIZE X X X X X X X X X X X X
SLICE X X X X X X X
SPACE X X X X X X X X X X X X
SPLIT X X X X X X X X X X
SQRT X X X X X X X X X X X X
SQUARE X X X X X X X X X X X X
STARTSWITH (массивы) X X X X X X X
STARTSWITH (строковая) X X X X X X X X X X X X X
STDEV X X X X X X X X X X X X
STDEVP X X X X X X X X X X X X
STR X X X X X X X X X X X X
SUBSTR X X X X X X X X X X X X
SUM X X X X X X X X X X X X
SUM (оконная) X X X X X X X X X X X
SUM_IF X X X X X X X X X X X X
SUM_IF (оконная) X X X X X X X X X X X
TAN X X X X X X X X X X X X
TODAY X X X X X X X X X X X X
TOOLTIP X X X X X X X X X X X X
TOP_CONCAT X X X X X X
TREE X X X X X X X
TRIM X X X X X X X X X X X
UNNEST X X X X X X X
UPPER X X X X X X X X X X X X
URL X X X X X X X X X X X X
USER_INFO
UTF8 X X X X X
VAR X X X X X X X X X X X X
VARP X X X X X X X X X X X X
WEEK X X X X X X X X X X X X
YEAR X X X X X X X X X X X X
ZN X X X X X X X X X X X X