Подключиться
Yandex DataLens

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

Статья создана
,
улучшена

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

    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
    5.7    		 MySQL
    8.0.12    		 Microsoft
    SQL Server 2017
    (14.0)    		 Oracle
    Database 12c
    (12.1)    		 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 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
    ACOS 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
    ALL_CONCAT X X X X X X X
    AND X X X X X X X X X X X X X
    ANY X X X X X X X
    ARG_MAX X X X X X
    ARG_MIN X X X X X
    ASCII 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
    ATAN 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
    AT_DATE 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 (оконная) 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
    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
    BOLD 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
    CASE X X X X X X X X X X X X
    CEILING 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
    CONCAT X X X X X X X X X X X X X
    CONTAINS X X X X X X X X X X X X X
    COS 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
    COUNT 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
    COUNTD_APPROX X X X X X X
    COUNTD_IF 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_IF (оконная) X X X X X X X X X X X X
    DATE 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
    DATEPART 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
    DATETIME_PARSE X X X X X
    DATETRUNC 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
    DAYOFWEEK X X X X X X X X X X X X
    DB_CAST X X X X X X X
    DEGREES 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
    ENDSWITH 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
    FIND 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
    FLOOR X X 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 X X
    GEOPOLYGON X X X X X X X X X X X X
    GREATEST 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
    ICONTAINS 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
    IF 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
    IN 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
    IS FALSE 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
    ISNULL 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
    ITALIC 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
    LEFT X X X X X X X X X X X X
    LEN 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
    LN 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
    LOG10 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
    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
    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
    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
    MEDIAN X X X X X X X X
    MIN 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
    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
    MSUM (оконная) X X X X X X X X X X X X
    NOT 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
    OR 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
    POWER X X X X X X X X X X X X
    QUANTILE X X X X X X X X
    QUANTILE_APPROX X X X X X
    QUARTER 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
    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
    REGEXP_EXTRACT_NTH 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
    REPLACE 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
    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
    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
    SIGN 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
    SPACE X X X X X X X X X X X X
    SPLIT X X X X X X X X X X
    SQRT 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
    STARTSWITH 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
    STDEVP 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
    SUBSTR 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 (оконная) 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
    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
    TODAY X X X X X X X X X X X X
    TOPONYM_TO_GEOPOINT X
    TOPONYM_TO_GEOPOLYGON X
    TOP_CONCAT X X X X X
    TRIM X X X X X X X X X X X X
    UPPER 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
    UTF8 X X X X X
    VAR 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
    WEEK 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
    ZN X X X X X X X X X X X X