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

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

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)	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
ABS	X	X	X	X	X	X	X	X	X	X	X
ACOS	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
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
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
AVG	X	X	X	X	X	X	X	X	X	X	X
AVG
AVG_IF	X	X	X	X	X	X	X	X	X	X	X
AVG_IF
BETWEEN	X	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
CEILING	X	X	X	X	X	X	X	X	X	X	X
CHAR	X	X	X	X	X	X	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	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
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
DATE	X	X	X	X	X	X	X	X	X	X	X
DATEADD	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
DATETIME_PARSE	X	X	X	X	X
DATETRUNC	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
DAYOFWEEK	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
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
FLOAT	X	X	X	X	X	X	X	X	X	X	X
FLOOR	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
GEOPOLYGON	X	X	X	X	X	X	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
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	X
MAVG
MAX	X	X	X	X	X	X	X	X	X	X	X
MAX
MCOUNT
MEDIAN	X	X	X	X	X
MIN	X	X	X	X	X	X	X	X	X	X	X
MIN
MINUTE	X	X	X	X	X	X	X	X	X	X	X
MMAX
MMIN
MONTH	X	X	X	X	X	X	X	X	X	X	X
MSUM
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
QUANTILE_APPROX	X	X	X	X	X
RADIANS	X	X	X	X	X	X	X	X	X	X	X
RANK
RANK_DENSE
RANK_PERCENTILE
RANK_UNIQUE
RAVG
RCOUNT
REGEXP_EXTRACT	X	X	X	X	X	X	X			X
REGEXP_EXTRACT_NTH	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
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
RMIN
ROUND	X	X	X	X	X	X	X	X	X	X	X
RSUM
RTRIM	X	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
SPACE	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
SQUARE	X	X	X	X	X	X	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
SUM_IF	X	X	X	X	X	X	X	X	X	X	X
SUM_IF
TAN	X	X	X	X	X	X	X	X	X	X	X
TODAY	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
UPPER	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
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