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

Статья создана

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

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
AGO	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
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	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
FIRST (оконная)	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
LAG (оконная)	X	X	X	X	X	X	X	X	X	X	X	X
LAST (оконная)	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		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		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	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