[Yandex Cloud documentation](../../index.md) > [Yandex DataLens](../index.md) > Calculated fields > Function reference > Function Availability # Function Availability Function availability for various data source types. | Function | `ClickHouse`
`21.8` | `ClickHouse`
`22.10` | `Files` | `Google Sheets` | `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` | `Trino` | `Yandex Documents` | `YDB`
(`YQL`) | |:------------------------------------------------|:-------------------------:|:--------------------------:|:---------:|:-----------------:|:------------------:|:------------------------------------------------:|:-------------------:|:----------------------:|:------------------------------------------:|:------------------------:|:------------------------:|:---------:|:--------------------:|:-------------------:| | [Addition and concatenation (+)](OP_PLUS.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [Comparison](OP_COMPARISON.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [Division (/)](OP_DIV.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [Modulo (%)](OP_MOD.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [Multiplication (*)](OP_MULT.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [Negation (-)](OP_NEGATION.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [Power (^)](OP_POWER.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [Subtraction (-)](OP_MINUS.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [ABS](ABS.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [ACOS](ACOS.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [AGO](AGO.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [ALL_CONCAT](ALL_CONCAT.md) | X | X | X | X | | | | | | X | X | | X | X | | [AND](AND.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [ANY](ANY.md) | X | X | X | X | | | X | X | | | | X | X | X | | [ARG_MAX](ARG_MAX.md) | X | X | X | X | | | | | | | | X | X | X | | [ARG_MIN](ARG_MIN.md) | X | X | X | X | | | | | | | | X | X | X | | [ARRAY](ARRAY.md) | X | X | X | X | | | | | | X | X | X | X | | | [ARR_AVG](ARR_AVG.md) | X | X | X | X | | | | | | | | | X | | | [ARR_DISTINCT](ARR_DISTINCT.md) | X | X | X | X | | | | | | X | X | X | X | | | [ARR_INDEX_OF](ARR_INDEX_OF.md) | X | X | X | X | | | | | | X | X | X | X | | | [ARR_INTERSECT](ARR_INTERSECT.md) | X | X | X | X | | | | | | X | X | X | X | | | [ARR_MAX](ARR_MAX.md) | X | X | X | X | | | | | | | | | X | | | [ARR_MIN](ARR_MIN.md) | X | X | X | X | | | | | | | | | X | | | [ARR_PRODUCT](ARR_PRODUCT.md) | X | X | X | X | | | | | | | | | X | | | [ARR_REMOVE](ARR_REMOVE.md) | X | X | X | X | | | | | | X | X | X | X | | | [ARR_STR](ARR_STR.md) | X | X | X | X | | | | | | X | X | X | X | | | [ARR_SUM](ARR_SUM.md) | X | X | X | X | | | | | | | | | X | | | [ASCII](ASCII.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [ASIN](ASIN.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [ATAN](ATAN.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [ATAN2](ATAN2.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [AT_DATE](AT_DATE.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [AVG](AVG.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [AVG (window)](AVG_WINDOW.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [AVG_IF](AVG_IF.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [AVG_IF (window)](AVG_IF_WINDOW.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [BETWEEN](BETWEEN.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [BOLD](BOLD.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [BOOL](BOOL.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [BR](BR.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [CASE](CASE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [CAST_ARR_FLOAT](CAST_ARR_FLOAT.md) | X | X | X | X | | | | | | X | X | X | X | | | [CAST_ARR_INT](CAST_ARR_INT.md) | X | X | X | X | | | | | | X | X | X | X | | | [CAST_ARR_STR](CAST_ARR_STR.md) | X | X | X | X | | | | | | X | X | X | X | | | [CEILING](CEILING.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [CHAR](CHAR.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [CITYHASH64](CITYHASH64.md) | X | X | | | | | | | | | | | | X | | [COLOR](COLOR.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [COMPARE](COMPARE.md) | X | X | X | X | | | | | | | | | X | | | [CONCAT](CONCAT.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [CONTAINS (array)](CONTAINS_ARRAY.md) | X | X | X | X | | | | | | X | X | X | X | | | [CONTAINS (string)](CONTAINS.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [CONTAINS_ALL](CONTAINS_ALL.md) | X | X | X | X | | | | | | X | X | X | X | | | [CONTAINS_ANY](CONTAINS_ANY.md) | X | X | X | X | | | | | | X | X | X | X | | | [CONTAINS_SUBSEQUENCE](CONTAINS_SUBSEQUENCE.md) | X | X | X | X | | | | | | | | | X | | | [COS](COS.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [COT](COT.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [COUNT](COUNT.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [COUNT (window)](COUNT_WINDOW.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [COUNTD](COUNTD.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [COUNTD_APPROX](COUNTD_APPROX.md) | X | X | X | X | | | | | X | | | X | X | X | | [COUNTD_IF](COUNTD_IF.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [COUNT_IF](COUNT_IF.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [COUNT_IF (window)](COUNT_IF_WINDOW.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [COUNT_ITEM](COUNT_ITEM.md) | X | X | X | X | | | | | | X | X | X | X | | | [DATE](DATE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [DATEADD](DATEADD.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [DATEPART](DATEPART.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [DATETIME](DATETIME.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [DATETIME_PARSE](DATETIME_PARSE.md) | X | X | X | X | | | | | | | | | X | | | [DATETRUNC](DATETRUNC.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [DATE_PARSE](DATE_PARSE.md) | X | X | X | X | | | | | | | | | X | | | [DAY](DAY.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [DAYOFWEEK](DAYOFWEEK.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [DB_CALL_AGG_FLOAT](DB_CALL_AGG_FLOAT.md) | X | X | | | | X | X | X | X | X | X | X | | X | | [DB_CALL_AGG_INT](DB_CALL_AGG_INT.md) | X | X | | | | X | X | X | X | X | X | X | | X | | [DB_CALL_AGG_STRING](DB_CALL_AGG_STRING.md) | X | X | | | | X | X | X | X | X | X | X | | X | | [DB_CALL_ARRAY_FLOAT](DB_CALL_ARRAY_FLOAT.md) | X | X | | | | X | X | X | X | X | X | X | | X | | [DB_CALL_ARRAY_INT](DB_CALL_ARRAY_INT.md) | X | X | | | | X | X | X | X | X | X | X | | X | | [DB_CALL_ARRAY_STRING](DB_CALL_ARRAY_STRING.md) | X | X | | | | X | X | X | X | X | X | X | | X | | [DB_CALL_BOOL](DB_CALL_BOOL.md) | X | X | | | | X | X | X | X | X | X | X | | X | | [DB_CALL_FLOAT](DB_CALL_FLOAT.md) | X | X | | | | X | X | X | X | X | X | X | | X | | [DB_CALL_INT](DB_CALL_INT.md) | X | X | | | | X | X | X | X | X | X | X | | X | | [DB_CALL_STRING](DB_CALL_STRING.md) | X | X | | | | X | X | X | X | X | X | X | | X | | [DB_CAST](DB_CAST.md) | X | X | X | X | | | | | | X | X | X | X | X | | [DEGREES](DEGREES.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [DIV](DIV.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [DIV_SAFE](DIV_SAFE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [ENDSWITH](ENDSWITH.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [EXP](EXP.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [FDIV_SAFE](FDIV_SAFE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [FIND](FIND.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [FIRST (window)](FIRST.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [FLOAT](FLOAT.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [FLOOR](FLOOR.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [GEOPOINT](GEOPOINT.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [GEOPOLYGON](GEOPOLYGON.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [GET_ITEM](GET_ITEM.md) | X | X | X | X | | | | | | X | X | X | X | | | [GREATEST](GREATEST.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [HOUR](HOUR.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [ICONTAINS](ICONTAINS.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [IENDSWITH](IENDSWITH.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [IF](IF.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [IFNULL](IFNULL.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [IMAGE](IMAGE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [IN](IN.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [INT](INT.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [INTHASH64](INTHASH64.md) | X | X | | | | | | | | | | | | X | | [IS FALSE](ISFALSE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [IS TRUE](ISTRUE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [ISNULL](ISNULL.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [ISTARTSWITH](ISTARTSWITH.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [ITALIC](ITALIC.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [LAG (window)](LAG.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [LAST (window)](LAST.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [LEAST](LEAST.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [LEFT](LEFT.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [LEN (array)](LEN_ARRAY.md) | X | X | X | X | | | | | | X | X | X | X | | | [LEN](LEN.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [LIKE](LIKE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [LN](LN.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [LOG](LOG.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [LOG10](LOG10.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [LOWER](LOWER.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [LTRIM](LTRIM.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [MARKUP](MARKUP.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [MAVG (window)](MAVG.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [MAX](MAX.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [MAX (window)](MAX_WINDOW.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [MCOUNT (window)](MCOUNT.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [MD5](MD5.md) | X | X | | | | | X | X | X | X | X | X | | X | | [MEDIAN](MEDIAN.md) | X | X | X | X | | | | | X | | X | X | X | X | | [MIN](MIN.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [MIN (window)](MIN_WINDOW.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [MINUTE](MINUTE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [MMAX (window)](MMAX.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [MMIN (window)](MMIN.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [MONTH](MONTH.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [MSUM (window)](MSUM.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [MURMURHASH2_64](MURMURHASH2_64.md) | X | X | | | | | | | | | | | | X | | [NOT](OP_NOT.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [NOW](NOW.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [OR](OR.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [PI](PI.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [POWER](POWER.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [QUANTILE](QUANTILE.md) | X | X | X | X | | | | | X | | X | X | X | X | | [QUANTILE_APPROX](QUANTILE_APPROX.md) | X | X | X | X | | | | | | | | X | X | | | [QUARTER](QUARTER.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [RADIANS](RADIANS.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [RANK (window)](RANK.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [RANK_DENSE (window)](RANK_DENSE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [RANK_PERCENTILE (window)](RANK_PERCENTILE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [RANK_UNIQUE (window)](RANK_UNIQUE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [RAVG (window)](RAVG.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [RCOUNT (window)](RCOUNT.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [REGEXP_EXTRACT](REGEXP_EXTRACT.md) | X | X | X | X | | | | X | X | X | X | X | X | | | [REGEXP_EXTRACT_ALL](REGEXP_EXTRACT_ALL.md) | X | X | X | X | | | | | | X | X | X | X | | | [REGEXP_EXTRACT_NTH](REGEXP_EXTRACT_NTH.md) | X | X | X | X | | | | X | X | X | X | X | X | | | [REGEXP_MATCH](REGEXP_MATCH.md) | X | X | X | X | | | X | X | X | X | X | X | X | | | [REGEXP_REPLACE](REGEXP_REPLACE.md) | X | X | X | X | | | | X | X | X | X | X | X | | | [REPLACE (array)](REPLACE_ARRAY.md) | X | X | X | X | | | | | | X | X | X | X | | | [REPLACE (string)](REPLACE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [RIGHT](RIGHT.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [RMAX (window)](RMAX.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [RMIN (window)](RMIN.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [ROUND](ROUND.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [RSUM (window)](RSUM.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [RTRIM](RTRIM.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [SECOND](SECOND.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [SHA1](SHA1.md) | X | X | | | | | X | X | X | X | X | X | | X | | [SHA256](SHA256.md) | X | X | | | | | X | X | X | X | X | X | | X | | [SIGN](SIGN.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [SIN](SIN.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [SIPHASH64](SIPHASH64.md) | X | X | | | | | | | | | | | | X | | [SIZE](SIZE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [SLICE](SLICE.md) | X | X | X | X | | | | | | X | X | X | X | | | [SPACE](SPACE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [SPLIT](SPLIT.md) | X | X | X | X | | | X | X | | X | X | X | X | X | | [SQRT](SQRT.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [SQUARE](SQUARE.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [STARTSWITH (array)](STARTSWITH_ARRAY.md) | X | X | X | X | | | | | | X | X | X | X | | | [STARTSWITH (string)](STARTSWITH.md) | X | X | X | X | X | X | X | X | X | X | X | X | X | X | | [STDEV](STDEV.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [STDEVP](STDEVP.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [STR](STR.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [SUBSTR](SUBSTR.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [SUM](SUM.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [SUM (window)](SUM_WINDOW.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [SUM_IF](SUM_IF.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [SUM_IF (window)](SUM_IF_WINDOW.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [TAN](TAN.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [TODAY](TODAY.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [TOOLTIP](TOOLTIP.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [TOP_CONCAT](TOP_CONCAT.md) | X | X | X | X | | | | | | | | | X | X | | [TREE](TREE.md) | X | X | X | X | | | | | | X | X | X | X | | | [TRIM](TRIM.md) | X | X | X | X | | X | X | X | X | X | X | X | X | | | [UNNEST](UNNEST.md) | X | X | X | X | | | | | | X | X | | X | | | [UPPER](UPPER.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [URL](URL.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [USER_INFO](USER_INFO.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [UTF8](UTF8.md) | X | X | X | X | | | | | | | | | X | | | [VAR](VAR.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [VARP](VARP.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [WEEK](WEEK.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [YEAR](YEAR.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X | | [ZN](ZN.md) | X | X | X | X | | X | X | X | X | X | X | X | X | X |