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

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

    Function Материализованный<br/>датасет 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
    Вычитание (-) 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
    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