Поддержка функций
Ниже приведена информация о поддержке функций различными источниками.
Function | Материализованный датасет |
ClickHouse 1.1 |
ClickHouse 19.1.6 |
ClickHouse 19.3.3 |
ClickHouse 19.6.2 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Вычитание (-) | 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 | |
ALL_CONCAT | 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 | ||||||
ARG_MAX | X | X | X | X | X | ||||||||
ARG_MIN | 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 | |
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 | 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 | 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 | |
CASE | X | X | X | X | X | 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 | |
CONCAT | X | X | X | X | X | X | X | X | X | X | X | X | X |
CONTAINS | X | X | X | X | X | X | X | X | 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 | X | |
COUNTD | X | X | X | X | X | X | X | X | X | X | X | X | |
COUNTD_APPROX | 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 | 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 | |
DATETIME_PARSE | X | X | X | X | X | ||||||||
DATETRUNC | 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 | |
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 | |
FIND | X | 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 | |
GEOCODE | X | ||||||||||||
GEOINFO | 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 | |
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 | |
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 | |
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 | 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 | 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 | 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 | X | |
MCOUNT (оконная) | X | X | X | X | X | X | X | X | X | X | X | X | |
MEDIAN | 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 | 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 | X | |
MMIN (оконная) | X | 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 | 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 | ||||||||
QUANTILE_APPROX | 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 | X | |
RANK_DENSE (оконная) | X | X | X | X | X | X | X | X | X | X | X | X | |
RANK_PERCENTILE (оконная) | X | X | X | X | X | X | X | X | X | X | X | X | |
RANK_UNIQUE (оконная) | X | X | X | X | X | X | X | X | X | X | X | X | |
RAVG (оконная) | X | X | X | X | X | X | X | X | X | X | X | X | |
RCOUNT (оконная) | X | X | X | X | X | X | X | X | X | X | X | X | |
REGEXP_EXTRACT | X | X | 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 | X | ||
REGEXP_REPLACE | X | X | 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 | X | |
RMIN (оконная) | X | 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 | X | |
RTRIM | X | 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 | |
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 | 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 | 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 | 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 | |
TOPONYM_TO_GEOPOINT | X | ||||||||||||
TOPONYM_TO_GEOPOLYGON | X | ||||||||||||
TOP_CONCAT | X | X | X | X | X | ||||||||
TRIM | X | X | X | X | X | 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 | |
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 |