Поддержка функций
Ниже приведена информация о поддержке функций различными источниками.
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_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 | |
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 |