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

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

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 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
ABS	X	X	X	X	X	X	X	X	X	X
ACOS	X	X	X	X	X	X	X	X	X	X
AND	X	X	X	X	X	X	X	X	X	X	X
ASCII	X	X	X	X	X	X	X	X	X	X
ASIN	X	X	X	X	X	X	X	X	X	X
ATAN	X	X	X	X	X	X	X	X	X	X
ATAN2	X	X	X	X	X	X	X	X	X	X
AVG	X	X	X	X	X	X	X	X	X	X
AVG
AVG_IF	X	X	X	X	X	X	X	X	X	X
AVG_IF
BETWEEN	X	X	X	X	X	X	X	X	X	X	X
BOOL	X	X	X	X	X	X	X	X	X	X
CASE	X	X	X	X	X	X	X	X	X	X
CEILING	X	X	X	X	X	X	X	X	X	X
CHAR	X	X	X	X	X	X	X	X	X	X
CONCAT	X	X	X	X	X	X	X	X	X	X	X
CONTAINS	X	X	X	X	X	X	X	X	X	X	X
COS	X	X	X	X	X	X	X	X	X	X
COT	X	X	X	X	X	X	X	X	X	X
COUNT	X	X	X	X	X	X	X	X	X	X
COUNT
COUNTD	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
COUNT_IF	X	X	X	X	X	X	X	X	X	X
COUNT_IF
DATE	X	X	X	X	X	X	X	X	X	X
DATEADD	X	X	X	X	X	X	X	X	X	X
DATEPART	X	X	X	X	X	X	X	X	X	X
DATETIME	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
DAYOFWEEK	X	X	X	X	X	X	X	X	X	X
DEGREES	X	X	X	X	X	X	X	X	X	X
DIV	X	X	X	X	X	X	X	X	X	X
ENDSWITH	X	X	X	X	X	X	X	X	X	X	X
EXP	X	X	X	X	X	X	X	X	X	X
FIND	X	X	X	X	X	X	X	X	X	X
FLOAT	X	X	X	X	X	X	X	X	X	X
FLOOR	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
GEOPOLYGON	X	X	X	X	X	X	X	X	X	X
GREATEST	X	X	X	X	X	X	X	X	X	X
HOUR	X	X	X	X	X	X	X	X	X	X
ICONTAINS	X	X	X	X	X	X	X	X	X	X
IENDSWITH	X	X	X	X	X	X	X	X	X	X
IF	X	X	X	X	X	X	X	X	X	X
IFNULL	X	X	X	X	X	X	X	X	X	X
IN	X	X	X	X	X	X	X	X	X	X	X
INT	X	X	X	X	X	X	X	X	X	X
IS FALSE	X	X	X	X	X	X	X	X	X	X
IS TRUE	X	X	X	X	X	X	X	X	X	X
ISNULL	X	X	X	X	X	X	X	X	X	X
ISTARTSWITH	X	X	X	X	X	X	X	X	X	X
LEAST	X	X	X	X	X	X	X	X	X	X
LEFT	X	X	X	X	X	X	X	X	X	X
LEN	X	X	X	X	X	X	X	X	X	X
LIKE	X	X	X	X	X	X	X	X	X	X
LN	X	X	X	X	X	X	X	X	X	X
LOG	X	X	X	X	X	X	X	X	X	X
LOG10	X	X	X	X	X	X	X	X	X	X
LOWER	X	X	X	X	X	X	X	X	X	X
LTRIM	X	X	X	X	X	X	X	X	X	X
MAVG
MAX	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
MIN
MINUTE	X	X	X	X	X	X	X	X	X	X
MMAX
MMIN
MONTH	X	X	X	X	X	X	X	X	X	X
MSUM
NOT	X	X	X	X	X	X	X	X	X	X	X
NOW	X	X	X	X	X	X	X	X	X	X
OR	X	X	X	X	X	X	X	X	X	X	X
PI	X	X	X	X	X	X	X	X	X	X
POWER	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
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
REGEXP_REPLACE	X	X	X	X	X	X	X		X
REPLACE	X	X	X	X	X	X	X	X	X	X
RIGHT	X	X	X	X	X	X	X	X	X	X
RMAX
RMIN
ROUND	X	X	X	X	X	X	X	X	X	X
RSUM
RTRIM	X	X	X	X	X	X	X	X	X	X
SECOND	X	X	X	X	X	X	X	X	X	X
SIGN	X	X	X	X	X	X	X	X	X	X
SIN	X	X	X	X	X	X	X	X	X	X
SPACE	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
SQUARE	X	X	X	X	X	X	X	X	X	X
STARTSWITH	X	X	X	X	X	X	X	X	X	X	X
STDEV	X	X	X	X	X	X	X	X	X	X
STDEVP	X	X	X	X	X	X	X	X	X	X
STR	X	X	X	X	X	X	X	X	X	X
SUBSTR	X	X	X	X	X	X	X	X	X	X
SUM	X	X	X	X	X	X	X	X	X	X
SUM
SUM_IF	X	X	X	X	X	X	X	X	X	X
SUM_IF
TAN	X	X	X	X	X	X	X	X	X	X
TODAY	X	X	X	X	X	X	X	X	X	X
TOPONYM_TO_GEOPOINT	X
TOPONYM_TO_GEOPOLYGON	X
TRIM	X	X	X	X	X	X	X	X	X	X
UPPER	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
VARP	X	X	X	X	X	X	X	X	X	X
WEEK	X	X	X	X	X	X	X	X	X	X
YEAR	X	X	X	X	X	X	X	X	X	X
ZN	X	X	X	X	X	X	X	X	X	X