Поддержка функций
Ниже приведена информация о поддержке функций различными источниками.
Function | Материализованный датасет |
ClickHouse 19.13 |
ClickHouse 21.8 |
PostgreSQL 9.3 |
PostgreSQL 9.4 |
MySQL 5.6 |
MySQL 5.7 |
MySQL 8.0.12 |
Microsoft SQL Server 2017 (14.0) |
Oracle Database 12c (12.1) |
Yandex Metrica |
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 |
ABS | X | X | X | X | X | X | X | X | X | X | X | |
ACOS | X | X | X | X | X | X | X | X | X | X | X | |
AGO | X | X | X | X | X | X | X | X | X | X | X | X |
ALL_CONCAT | X | X | X | X | X | X | ||||||
AND | X | X | X | X | X | X | X | X | X | X | X | X |
ANY | X | X | X | X | X | X | ||||||
ARG_MAX | X | X | X | X | ||||||||
ARG_MIN | X | X | X | X | ||||||||
ARRAY | X | X | X | X | X | |||||||
ARR_AVG | X | |||||||||||
ARR_MAX | X | |||||||||||
ARR_MIN | X | |||||||||||
ARR_PRODUCT | X | |||||||||||
ARR_REMOVE | X | X | X | X | X | |||||||
ARR_STR | X | X | X | X | X | |||||||
ARR_SUM | X | |||||||||||
ASCII | X | X | X | X | X | X | X | X | X | X | X | |
ASIN | X | X | X | X | X | X | X | X | X | X | X | |
ATAN | X | X | X | X | X | X | X | X | X | X | X | |
ATAN2 | 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 |
AVG | X | X | X | X | X | X | X | X | X | X | X | |
AVG (оконная) | X | X | X | X | X | X | X | X | X | X | ||
AVG_IF | X | X | X | X | X | X | X | X | X | X | X | |
AVG_IF (оконная) | X | X | X | X | X | X | X | X | X | X | ||
BETWEEN | X | X | X | X | X | X | X | X | X | X | X | X |
BOLD | X | X | X | X | X | X | X | X | X | X | X | |
BOOL | X | X | X | X | X | X | X | X | X | X | X | |
CASE | X | X | X | X | X | X | X | X | X | X | X | |
CAST_ARR_FLOAT | X | X | X | X | X | |||||||
CAST_ARR_INT | X | X | X | X | X | |||||||
CAST_ARR_STR | X | X | X | X | X | |||||||
CEILING | X | X | X | X | X | X | X | X | X | X | X | |
CHAR | X | X | X | X | X | X | X | X | X | X | X | |
COMPARE | X | X | X | |||||||||
CONCAT | X | X | X | X | X | X | X | X | X | X | X | X |
CONTAINS (массивы) | X | X | X | X | X | |||||||
CONTAINS (строковая) | X | X | X | X | X | X | X | X | X | X | X | X |
COS | X | X | X | X | X | X | X | X | X | X | X | |
COT | X | X | X | X | X | X | X | X | X | X | X | |
COUNT | X | X | X | X | X | X | X | X | X | X | X | |
COUNT (оконная) | X | X | X | X | X | X | X | X | X | X | ||
COUNTD | X | X | X | X | X | X | X | X | X | X | X | |
COUNTD_APPROX | X | X | X | X | X | |||||||
COUNTD_IF | 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_IF (оконная) | X | X | X | X | X | X | X | X | X | X | ||
COUNT_ITEM | X | X | X | X | X | |||||||
DATE | X | X | X | X | X | X | X | X | X | X | X | |
DATEADD | X | X | X | X | X | X | X | X | X | X | X | X |
DATEPART | X | X | X | X | X | X | X | X | X | X | X | |
DATETIME | X | X | X | X | X | X | X | X | X | X | X | X |
DATETIME_PARSE | X | X | X | |||||||||
DATETRUNC | X | X | X | X | X | X | X | X | X | X | X | |
DATE_PARSE | X | X | X | |||||||||
DAY | X | X | X | X | X | X | X | X | X | X | X | |
DAYOFWEEK | X | X | X | X | X | X | X | X | X | X | X | |
DB_CAST | X | X | X | X | X | |||||||
DEGREES | X | X | X | X | X | X | X | X | X | X | X | |
DIV | X | X | X | X | X | X | X | X | X | X | X | |
ENDSWITH | X | X | X | X | X | X | X | X | X | X | X | X |
EXP | X | X | X | X | X | X | X | X | X | X | X | |
FIND | X | X | X | X | X | X | X | X | X | X | X | |
FIRST (оконная) | X | X | X | X | X | X | X | X | X | X | ||
FLOAT | X | X | X | X | X | X | X | X | X | X | X | |
FLOOR | X | X | X | X | X | X | X | X | X | X | X | |
GEOPOINT | X | X | X | X | X | X | X | X | X | X | X | |
GEOPOLYGON | X | X | X | X | X | X | X | X | X | X | X | |
GET_ITEM | X | X | X | X | X | |||||||
GREATEST | X | X | X | X | X | X | X | X | X | X | X | |
HOUR | X | X | X | X | X | X | X | X | X | X | X | |
ICONTAINS | X | X | X | X | X | X | X | X | X | X | X | |
IENDSWITH | X | X | X | X | X | X | X | X | X | X | X | |
IF | X | X | X | X | X | X | X | X | X | X | X | |
IFNULL | X | X | X | X | X | X | X | X | X | X | X | |
IN | X | X | X | X | X | X | X | X | X | X | X | X |
INT | X | X | X | X | X | X | X | X | X | X | X | |
IS FALSE | X | X | X | X | X | X | X | X | X | X | X | |
IS TRUE | X | X | X | X | X | X | X | X | X | X | X | |
ISNULL | X | X | X | X | X | X | X | X | X | X | X | |
ISTARTSWITH | X | X | X | X | X | X | X | X | X | X | X | |
ITALIC | X | X | X | X | X | X | X | X | X | X | X | |
LAG (оконная) | X | X | X | X | X | X | X | X | X | X | ||
LAST (оконная) | X | X | X | X | X | X | X | X | X | X | ||
LEAST | X | X | X | X | X | X | X | X | X | X | X | |
LEFT | X | X | X | X | X | X | X | X | X | X | X | |
LEN | X | X | X | X | X | X | X | X | X | X | X | |
LIKE | X | X | X | X | X | X | X | X | X | X | X | |
LN | X | X | X | X | X | X | X | X | X | X | X | |
LOG | X | X | X | X | X | X | X | X | X | X | X | |
LOG10 | X | X | X | X | X | X | X | X | X | X | X | |
LOWER | X | X | X | X | X | X | X | X | X | X | X | |
LTRIM | X | X | X | X | X | X | X | X | X | X | ||
MARKUP | X | X | X | X | X | X | X | X | X | X | X | |
MAVG (оконная) | X | X | X | X | X | X | X | X | X | X | ||
MAX | X | X | X | X | X | X | X | X | X | X | X | |
MAX (оконная) | X | X | X | X | X | X | X | X | X | X | ||
MCOUNT (оконная) | X | X | X | X | X | X | X | X | X | X | ||
MEDIAN | X | X | X | X | X | X | ||||||
MIN | X | X | X | X | X | X | X | X | X | X | X | |
MIN (оконная) | X | X | X | X | X | X | X | X | X | X | ||
MINUTE | X | X | X | X | X | X | X | X | X | X | X | |
MMAX (оконная) | X | X | X | X | X | X | X | X | X | X | ||
MMIN (оконная) | X | X | X | X | X | X | X | X | X | X | ||
MONTH | X | X | X | X | X | X | X | X | X | X | X | |
MSUM (оконная) | X | X | X | X | X | X | X | X | X | X | ||
NOT | X | X | X | X | X | X | X | X | X | X | X | X |
NOW | X | X | X | X | X | X | X | X | X | X | X | |
OR | X | X | X | X | X | X | X | X | X | X | X | X |
PI | X | X | X | X | X | X | X | X | X | X | X | |
POWER | X | X | X | X | X | X | X | X | X | X | X | |
QUANTILE | X | X | X | X | X | X | ||||||
QUANTILE_APPROX | X | X | X | |||||||||
QUARTER | X | X | X | X | X | X | X | X | X | X | X | |
RADIANS | X | X | X | X | X | X | X | X | X | X | X | |
RANK (оконная) | X | X | X | X | X | X | X | X | X | X | ||
RANK_DENSE (оконная) | X | X | X | X | X | X | X | X | X | X | ||
RANK_PERCENTILE (оконная) | X | X | X | X | X | X | X | X | X | X | ||
RANK_UNIQUE (оконная) | X | X | X | X | X | X | X | X | X | X | ||
RAVG (оконная) | X | X | X | X | X | X | X | X | X | X | ||
RCOUNT (оконная) | X | X | X | X | X | X | X | X | X | X | ||
REGEXP_EXTRACT | X | X | X | X | X | X | X | |||||
REGEXP_EXTRACT_NTH | X | X | X | X | X | X | X | |||||
REGEXP_MATCH | X | X | X | X | X | X | X | X | X | |||
REGEXP_REPLACE | X | X | X | X | X | X | X | |||||
REPLACE (массивы) | X | X | X | X | X | |||||||
REPLACE (строковая) | X | X | X | X | X | X | X | X | X | X | X | |
RIGHT | X | X | X | X | X | X | X | X | X | X | X | |
RMAX (оконная) | X | X | X | X | X | X | X | X | X | X | ||
RMIN (оконная) | X | X | X | X | X | X | X | X | X | X | ||
ROUND | X | X | X | X | X | X | X | X | X | X | X | |
RSUM (оконная) | X | X | X | X | X | X | X | X | X | X | ||
RTRIM | X | X | X | X | X | X | X | X | X | X | ||
SECOND | X | X | X | X | X | X | X | X | X | X | X | |
SIGN | X | X | X | X | X | X | X | X | X | X | X | |
SIN | X | X | X | X | X | X | X | X | X | X | X | |
SLICE | X | X | X | X | X | |||||||
SPACE | X | X | X | X | X | X | X | X | X | X | X | |
SPLIT | X | X | X | X | X | X | X | X | X | |||
SQRT | X | X | X | X | X | X | X | X | X | X | X | |
SQUARE | X | X | X | X | X | X | X | X | X | X | X | |
STARTSWITH (массивы) | X | X | X | X | X | |||||||
STARTSWITH (строковая) | X | X | X | X | X | X | X | X | X | X | X | X |
STDEV | X | X | X | X | X | X | X | X | X | X | X | |
STDEVP | X | X | X | X | X | X | X | X | X | X | X | |
STR | X | X | X | X | X | X | X | X | X | X | X | |
SUBSTR | X | X | X | X | X | X | X | X | X | X | X | |
SUM | X | X | X | X | X | X | X | X | X | X | X | |
SUM (оконная) | X | X | X | X | X | X | X | X | X | X | ||
SUM_IF | X | X | X | X | X | X | X | X | X | X | X | |
SUM_IF (оконная) | X | X | X | X | X | X | X | X | X | X | ||
TAN | X | X | X | X | X | X | X | X | X | X | X | |
TODAY | X | X | X | X | X | X | X | X | X | X | X | |
TOP_CONCAT | X | X | X | X | ||||||||
TRIM | X | X | X | X | X | X | X | X | X | X | ||
UNNEST | X | X | X | X | X | |||||||
UPPER | X | X | X | X | X | X | X | X | X | X | X | |
URL | X | X | X | X | X | X | X | X | X | X | X | |
UTF8 | X | X | X | |||||||||
VAR | X | X | X | X | X | X | X | X | X | X | X | |
VARP | X | X | X | X | X | X | X | X | X | X | X | |
WEEK | X | X | X | X | X | X | X | X | X | X | X | |
YEAR | X | X | X | X | X | X | X | X | X | X | X | |
ZN | X | X | X | X | X | X | X | X | X | X | X |