Function Availability

    Function availability for various data source types.

    Function Materialized
    Dataset
    ClickHouse
    1.1
    ClickHouse
    19.1.6
    ClickHouse
    19.3.3
    ClickHouse
    19.6.2
    PostgreSQL
    9.3
    MySQL
    5.6
    MySQL
    8.0.12
    Microsoft
    SQL Server 2017
    (14.0)
    Yandex.Metrica
    Addition and concatenation (+) 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
    Modulo (%) X X X X X X X X X
    Multiplication (*) 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
    ABS X X X X X X X X X
    ACOS X X X X X X X X X
    AND X X X X X X X 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
    AVG X X X X X X X X X
    AVG_IF X X X X X X X X X
    BETWEEN X X X X X X X X X X
    BOOL X X X X X X X X X
    CASE X X X X X X X X X
    CEILING X X X X X X X X X
    CHAR X X X X X X X X X
    CONCAT X X X X X X X X X
    CONTAINS X X X X X X X 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
    COUNTD 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
    COUNT_IF X X X X X X X X X
    DATE X X X X X X X X X
    DATEADD 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
    DATETIME_PARSE X X X X X
    DATETRUNC X X X X X X
    DATE_PARSE X X X X X
    DAY X X X X X X X X X
    DAYOFWEEK X X X X X X X X X
    DEGREES X X X X X X X X X
    DIV X X X X X X X X X
    ENDSWITH X X X X X X X X X
    EXP X X X X X X X X X
    FIND X 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
    GEOCODE X
    GEOPOINT X X X X X X X X X
    GEOPOLYGON X X X X X 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
    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
    LEAST X X X X X X X X X
    LEFT X X X X X 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 X
    MAX X X X X X X X X X
    MEDIAN X X X X X
    MIN X X X X X X X X X
    MINUTE X X X X X X X X X
    MONTH X X X X X X X X X
    NOT 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
    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 X X X
    RADIANS X X X X X X X X X
    REGEXP_EXTRACT X X X X X X X
    REGEXP_EXTRACT_NTH X X X X X X X
    REGEXP_MATCH X X X X X X X X
    REGEXP_REPLACE X X X X X X X
    REPLACE X X X X X X X X X
    RIGHT X X X X X X X X X
    ROUND X X X X X X X X X
    RTRIM X 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
    SPACE X X X X X X X X X
    SPLIT X 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 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_IF X 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
    TRIM X X X X X X X X X
    UPPER 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
    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