Function Availability

Function availability for various data source types.

Function ClickHouse
21.8		 ClickHouse
22.10		 Yandex Metrica Microsoft
SQL Server 2017
(14.0)		 MySQL
5.7		 MySQL
8.0.12		 Oracle
Database 12c
(12.1)		 PostgreSQL
9.3		 PostgreSQL
9.4		 YDB
(YQL)
Addition and concatenation (+) X X X X X X X X X X
Comparison X X X X X X X X X X
Division (/) X X X X X X X X X X
Modulo (%) X X X X X X X X X
Multiplication (*) X X X X X X X X X X
Negation (-) X X X X X X X X X
Power (^) X X X X X X X X X
Subtraction (-) X X X X X X X X X X
ABS X X X X X X X X X
ACOS X X X X X X X X X
AGO X X X X X X X X X X
ALL_CONCAT X X X X X
AND X X X X X X X X X X
ANY X X X X X
ARG_MAX X X X
ARG_MIN X X X
ARRAY X X X X
ARR_AVG X X
ARR_MAX X X
ARR_MIN X X
ARR_PRODUCT X X
ARR_REMOVE X X X X
ARR_STR X X X X
ARR_SUM X X
ASCII X X X X X X X X X
ASIN X X X X X X X X X
ATAN X X X X X X X X X
ATAN2 X X X X X X X X X
AT_DATE X X X X X X X X X X
AVG X X X X X X X X X
AVG (window) X X X X X X X X
AVG_IF X X X X X X X X X
AVG_IF (window) X X X X X X X X
BETWEEN X X X X X X X X X X
BOLD X X X X X X X X X
BOOL X X X X X X X X X
BR X X X X X X X X X
CASE X X X X X X X X X
CAST_ARR_FLOAT X X X X
CAST_ARR_INT X X X X
CAST_ARR_STR X X X X
CEILING X X X X X X X X X
CHAR X X X X X X X X X
COLOR X X X X X X X X X
COMPARE X X
CONCAT X X X X X X X X X
CONTAINS (array) X X X X
CONTAINS (string) X X X X X X X X X X
CONTAINS_ALL X X X X
CONTAINS_ANY X X X X
CONTAINS_SUBSEQUENCE X X
COS X X X X X X X X X
COT X X X X X X X X X
COUNT X X X X X X X X X
COUNT (window) X X X X X X X X
COUNTD X X X X X X X X X
COUNTD_APPROX X X X X
COUNTD_IF X X X X X X X X X
COUNT_IF X X X X X X X X X
COUNT_IF (window) X X X X X X X X
COUNT_ITEM X X X X
DATE 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
DATETIME X X X X X X X X X X
DATETIME_PARSE X X
DATETRUNC X X X X X X X X X
DATE_PARSE X X
DAY X X X X X X X X X
DAYOFWEEK X X X X X X X X X
DB_CAST X X X X
DEGREES X X X X X X X X X
DIV X X X X X X X X X
DIV_SAFE X X X X X X X X X
ENDSWITH X X X X X X X X X X
EXP X X X X X X X X X
FDIV_SAFE X X X X X X X X X
FIND X X X X X X X X X
FIRST (window) X X X X X X X X
FLOAT X X X X X X X X X
FLOOR X X X X X X X X X
GEOPOINT X X X X X X X X X
GEOPOLYGON X X X X X X X X X
GET_ITEM X X X X
GREATEST X X X X X X X X X
HOUR X X X X X X X X X
ICONTAINS X X X X X X X X X
IENDSWITH X X X X X X X X X
IF X X X X X X X X X
IFNULL X X X X X X X X X
IMAGE X X X X X X X X X
IN X X X X X X X X X X
INT X X X X X X X X X
IS FALSE X X X X X X X X X
IS TRUE X X X X X X X X X
ISNULL X X X X X X X X X
ISTARTSWITH X X X X X X X X X
ITALIC X X X X X X X X X
LAG (window) X X X X X X X X
LAST (window) X X X X X X X X
LEAST X X X X X X X X X
LEFT X X X X X X X X X
LEN (array) X X X X
LEN X X X X X X X X X
LIKE X X X X X X X X X
LN X X X X X X X X X
LOG X X X X X X X X X
LOG10 X X X X X X X X X
LOWER X X X X X X X X X
LTRIM X X X X X X X X
MARKUP X X X X X X X X X
MAVG (window) X X X X X X X X
MAX X X X X X X X X X
MAX (window) X X X X X X X X
MCOUNT (window) X X X X X X X X
MEDIAN X X X X X
MIN X X X X X X X X X
MIN (window) X X X X X X X X
MINUTE X X X X X X X X X
MMAX (window) X X X X X X X X
MMIN (window) X X X X X X X X
MONTH X X X X X X X X X
MSUM (window) X X X X X X X X
NOT X X X X X X X X X X
NOW X X X X X X X X X
OR X X X X X X X X X X
PI X X X X X X X X X
POWER X X X X X X X X X
QUANTILE X X X X X
QUANTILE_APPROX X X
QUARTER X X X X X X X X X
RADIANS X X X X X X X X X
RANK (window) X X X X X X X X
RANK_DENSE (window) X X X X X X X X
RANK_PERCENTILE (window) X X X X X X X X
RANK_UNIQUE (window) X X X X X X X X
RAVG (window) X X X X X X X X
RCOUNT (window) X X X X X X X X
REGEXP_EXTRACT X X X X X X
REGEXP_EXTRACT_ALL X X X X
REGEXP_EXTRACT_NTH X X X X X X
REGEXP_MATCH X X X X X X X
REGEXP_REPLACE X X X X X X
REPLACE (array) X X X X
REPLACE (string) X X X X X X X X X
RIGHT X X X X X X X X X
RMAX (window) X X X X X X X X
RMIN (window) X X X X X X X X
ROUND X X X X X X X X X
RSUM (window) X X X X X X X X
RTRIM X X X X X X X X
SECOND X X X X X X X X X
SIGN X X X X X X X X X
SIN X X X X X X X X X
SIZE X X X X X X X X X
SLICE X X X X
SPACE X X X X X X X X X
SPLIT X X X X X X X
SQRT X X X X X X X X X
SQUARE X X X X X X X X X
STARTSWITH (array) X X X X
STARTSWITH (string) X X X X X X X X X X
STDEV X X X X X X X X X
STDEVP X X X X X X X X X
STR X X X X X X X X X
SUBSTR X X X X X X X X X
SUM X X X X X X X X X
SUM (window) X X X X X X X X
SUM_IF X X X X X X X X X
SUM_IF (window) X X X X X X X X
TAN X X X X X X X X X
TODAY X X X X X X X X X
TOP_CONCAT X X X
TREE X X X X
TRIM X X X X X X X X
UNNEST X X X X
UPPER X X X X X X X X X
URL X X X X X X X X X
USER_INFO
UTF8 X X
VAR X X X X X X X X X
VARP X X X X X X X X X
WEEK X X X X X X X X X
YEAR X X X X X X X X X
ZN X X X X X X X X X
Previous
SUM_IF
Next
Aggregate functions