Поддержка функций
Ниже приведена информация о поддержке функций различными источниками.
| Function | ClickHouse21.8 |
ClickHouse22.10 |
Файлы |
Google Sheets |
Yandex Metrica |
MicrosoftSQL Server 2017(14.0) |
MySQL5.7 |
MySQL8.0.12 |
OracleDatabase 12c(12.1) |
PostgreSQL9.3 |
PostgreSQL9.4 |
Trino |
Яндекс Документы |
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 | 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 | X | |
| ACOS | X | 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 | X | X |
| ALL_CONCAT | X | X | X | X | X | X | X | X | ||||||
| AND | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| ANY | X | X | X | X | X | X | X | X | X | |||||
| ARG_MAX | X | X | X | X | X | X | X | |||||||
| ARG_MIN | X | X | X | X | X | X | X | |||||||
| ARRAY | X | X | X | X | X | X | X | X | ||||||
| ARR_AVG | X | X | X | X | X | |||||||||
| ARR_DISTINCT | X | X | X | X | X | X | X | X | ||||||
| ARR_INDEX_OF | X | X | X | X | X | X | X | X | ||||||
| ARR_INTERSECT | X | X | X | X | X | X | X | X | ||||||
| ARR_MAX | X | X | X | X | X | |||||||||
| ARR_MIN | X | X | X | X | X | |||||||||
| ARR_PRODUCT | X | X | X | X | X | |||||||||
| ARR_REMOVE | X | X | X | X | X | X | X | X | ||||||
| ARR_STR | X | X | X | X | X | X | X | X | ||||||
| ARR_SUM | X | X | X | X | X | |||||||||
| ASCII | X | 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 | X | |
| ATAN | X | 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 | X | |
| AT_DATE | X | X | 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 | 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 | 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 | X |
| BOLD | X | 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 | X | |
| BR | X | 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 | X | |
| CAST_ARR_FLOAT | X | X | X | X | X | X | X | X | ||||||
| CAST_ARR_INT | X | X | X | X | X | X | X | X | ||||||
| CAST_ARR_STR | X | X | X | X | X | X | X | X | ||||||
| CEILING | X | 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 | X | |
| CITYHASH64 | X | X | X | |||||||||||
| COLOR | X | X | X | X | X | X | X | X | X | X | X | X | X | |
| COMPARE | 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 | ||||||
| CONTAINS (строковая) | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| CONTAINS_ALL | X | X | X | X | X | X | X | X | ||||||
| CONTAINS_ANY | X | X | X | X | X | X | X | X | ||||||
| CONTAINS_SUBSEQUENCE | X | X | X | X | X | |||||||||
| COS | X | 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 | X | |
| COUNT | X | 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 | X | |
| COUNTD_APPROX | X | X | X | X | X | X | X | X | ||||||
| COUNTD_IF | X | 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 | X | |
| COUNT_IF (оконная) | X | X | X | X | X | X | X | X | X | X | X | X | ||
| COUNT_ITEM | X | X | X | X | X | X | X | X | ||||||
| DATE | X | 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 | X |
| DATEPART | X | 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 | X | X |
| DATETIME_PARSE | X | X | X | X | X | |||||||||
| DATETRUNC | X | X | X | X | X | 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 | X | |
| DAYOFWEEK | X | X | X | X | X | X | X | X | X | X | X | X | X | |
| DB_CALL_AGG_FLOAT | X | X | X | X | X | X | X | X | X | X | ||||
| DB_CALL_AGG_INT | X | X | X | X | X | X | X | X | X | X | ||||
| DB_CALL_AGG_STRING | X | X | X | X | X | X | X | X | X | X | ||||
| DB_CALL_ARRAY_FLOAT | X | X | X | X | X | X | X | X | X | X | ||||
| DB_CALL_ARRAY_INT | X | X | X | X | X | X | X | X | X | X | ||||
| DB_CALL_ARRAY_STRING | X | X | X | X | X | X | X | X | X | X | ||||
| DB_CALL_BOOL | X | X | X | X | X | X | X | X | X | X | ||||
| DB_CALL_FLOAT | X | X | X | X | X | X | X | X | X | X | ||||
| DB_CALL_INT | X | X | X | X | X | X | X | X | X | X | ||||
| DB_CALL_STRING | X | X | X | X | X | X | X | X | X | X | ||||
| DB_CAST | X | X | X | X | X | X | X | X | X | |||||
| DEGREES | X | 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 | X | |
| DIV_SAFE | X | 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 | X |
| EXP | X | X | X | X | X | X | X | X | X | X | X | X | X | |
| FDIV_SAFE | X | 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 | 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 | X | |
| FLOOR | X | X | X | X | X | X | X | X | X | X | X | X | X | |
| GEOPOINT | X | 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 | X | |
| GET_ITEM | X | X | X | X | X | X | X | X | ||||||
| GREATEST | X | 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 | X | |
| ICONTAINS | X | 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 | X | |
| IF | X | 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 | X | |
| IMAGE | X | 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 | X |
| INT | X | X | X | X | X | X | X | X | X | X | X | X | X | |
| INTHASH64 | X | X | X | |||||||||||
| IS FALSE | X | 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 | X | |
| ISNULL | X | 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 | X | |
| ITALIC | X | 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 | X | |
| LEFT | X | X | X | X | X | X | X | X | X | X | X | X | X | |
| LEN (массивы) | X | X | X | X | X | X | X | X | ||||||
| LEN | X | 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 | X | |
| LN | X | 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 | X | |
| LOG10 | X | 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 | 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 | 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 | 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 | ||
| MD5 | X | X | X | X | X | X | X | X | X | |||||
| MEDIAN | X | X | X | X | X | X | X | X | X | |||||
| MIN | X | 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 | 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 | X | |
| MSUM (оконная) | X | X | X | X | X | X | X | X | X | X | X | X | ||
| MURMURHASH2_64 | X | X | X | |||||||||||
| NOT | X | 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 | X | |
| OR | X | 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 | X | |
| POWER | X | X | X | X | X | X | X | X | X | X | X | X | X | |
| QUANTILE | X | X | X | X | X | X | X | X | X | |||||
| QUANTILE_APPROX | X | X | X | X | X | X | ||||||||
| QUARTER | X | 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 | 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 | X | ||||
| REGEXP_EXTRACT_ALL | X | X | X | X | X | X | X | X | ||||||
| REGEXP_EXTRACT_NTH | X | 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 | X | ||||
| REPLACE (массивы) | X | X | X | X | X | X | X | X | ||||||
| REPLACE (строковая) | X | 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 | 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 | 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 | X | |
| SHA1 | X | X | X | X | X | X | X | X | X | |||||
| SHA256 | X | X | X | X | X | X | X | X | X | |||||
| SIGN | X | 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 | X | |
| SIPHASH64 | X | X | X | |||||||||||
| SIZE | X | X | X | X | X | X | X | X | X | X | X | X | X | |
| SLICE | X | X | X | X | X | X | X | X | ||||||
| SPACE | X | X | X | X | X | X | X | X | X | X | X | X | X | |
| SPLIT | X | X | X | X | X | X | X | X | X | X | X | |||
| SQRT | X | 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 | X | |
| STARTSWITH (массивы) | X | X | X | X | X | X | X | X | ||||||
| STARTSWITH (строковая) | X | 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 | X | |
| STDEVP | X | 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 | X | |
| SUBSTR | X | 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 | 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 | 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 | X | |
| TODAY | X | X | X | X | X | X | X | X | X | X | X | X | X | |
| TOOLTIP | X | X | X | X | X | X | X | X | X | X | X | X | X | |
| TOP_CONCAT | X | X | X | X | X | X | ||||||||
| TREE | X | X | X | X | X | X | X | X | ||||||
| TRIM | X | X | X | X | X | X | X | X | X | X | X | X | ||
| UNNEST | X | X | X | X | X | X | X | |||||||
| UPPER | X | 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 | X | |
| USER_INFO | X | 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 | X | |
| VARP | X | 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 | X | |
| YEAR | X | 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 | X |