# ColumnStore Distributed Functions

## Functions

ColumnStore supports the following functions. These functions can be specified in the projection (`SELECT`), `WHERE` and `ORDER BY` portions of the SQL statement and will be processed in a distributed manner.

* [&](/docs/server/reference/sql-functions/secondary-functions/bit-functions-and-operators/bitwise_and.md)
* [ABS()](/docs/server/reference/sql-functions/numeric-functions/abs.md)
* [ACOS()](/docs/server/reference/sql-functions/numeric-functions/acos.md)
* [ADDDATE()](/docs/server/reference/sql-functions/date-time-functions/adddate.md)
* [ADDTIME()](/docs/server/reference/sql-functions/date-time-functions/addtime.md)
* [ASCII()](/docs/server/reference/sql-functions/string-functions/ascii.md)
* [ASIN()](/docs/server/reference/sql-functions/numeric-functions/asin.md)
* [ATAN()](/docs/server/reference/sql-functions/numeric-functions/atan.md)
* [BETWEEN...AND...](/docs/server/reference/sql-structure/operators/comparison-operators/between-and.md)
* [BIT\_AND()](/docs/server/reference/sql-functions/aggregate-functions/bit_and.md)
* [BIT\_OR()](/docs/server/reference/sql-functions/aggregate-functions/bit_or.md)
* [BIT\_XOR()](/docs/server/reference/sql-functions/aggregate-functions/bit_xor.md)
* [CASE()](/docs/server/reference/sql-functions/control-flow-functions/case-operator.md)
* [CAST()](/docs/server/reference/sql-functions/string-functions/cast.md)
* [CEIL()](/docs/server/reference/sql-functions/numeric-functions/ceil.md), [CEILING()](/docs/server/reference/sql-functions/numeric-functions/ceiling.md)
* [CHAR\_LENGTH(), CHARACTER\_LENGTH()](/docs/server/reference/sql-functions/string-functions/char_length.md)
* [COALESCE()](/docs/server/reference/sql-structure/operators/comparison-operators/coalesce.md)
* [CONCAT()](/docs/server/reference/sql-functions/string-functions/concat.md)
* [CONCAT\_WS()](/docs/server/reference/sql-functions/string-functions/concat_ws.md)
* [CONV()](/docs/server/reference/sql-functions/numeric-functions/conv.md)
* [CONVERT()](/docs/server/reference/sql-functions/string-functions/convert.md)
* [COS()](/docs/server/reference/sql-functions/numeric-functions/cos.md)
* [COT()](/docs/server/reference/sql-functions/numeric-functions/cot.md)
* [CRC32()](/docs/server/reference/sql-functions/numeric-functions/crc32.md)
* [DATE()](/docs/server/reference/sql-functions/date-time-functions/date-function.md)
* [DATE\_ADD()](/docs/server/reference/sql-functions/date-time-functions/date_add.md)
* [DATE\_FORMAT()](/docs/server/reference/sql-functions/date-time-functions/date_format.md)
* [DATE\_SUB()](/docs/server/reference/sql-functions/date-time-functions/date_sub.md)
* [DATEDIFF()](/docs/server/reference/sql-functions/date-time-functions/datediff.md)
* [DAY(), DAYOFMONTH()](/docs/server/reference/sql-functions/date-time-functions/dayofmonth.md)
* [DAYNAME()](/docs/server/reference/sql-functions/date-time-functions/dayname.md)
* [DAYOFWEEK()](/docs/server/reference/sql-functions/date-time-functions/dayofweek.md)
* [DAYOFYEAR()](/docs/server/reference/sql-functions/date-time-functions/dayofyear.md)
* [DEGREES()](/docs/server/reference/sql-functions/numeric-functions/degrees.md)
* [DIV](/docs/server/reference/sql-functions/numeric-functions/div.md)
* [ELT()](/docs/server/reference/sql-functions/string-functions/elt.md)
* [EXP()](/docs/server/reference/sql-functions/numeric-functions/exp.md)
* [EXTRACT()](/docs/server/reference/sql-functions/date-time-functions/extract.md)
* [FIND\_IN\_SET()](/docs/server/reference/sql-functions/string-functions/find_in_set.md)
* [FLOOR()](/docs/server/reference/sql-functions/numeric-functions/floor.md)
* [FORMAT()](/docs/server/reference/sql-functions/string-functions/format.md)
* [FROM\_DAYS()](/docs/server/reference/sql-functions/date-time-functions/from_days.md)
* [FROM\_UNIXTIME()](/docs/server/reference/sql-functions/date-time-functions/from_unixtime.md)
* [GET\_FORMAT()](/docs/server/reference/sql-functions/date-time-functions/get_format.md)
* [GREATEST()](/docs/server/reference/sql-structure/operators/comparison-operators/greatest.md)
* [GROUP\_CONCAT()](/docs/server/reference/sql-functions/aggregate-functions/group_concat.md)
* [HEX()](/docs/server/reference/sql-functions/string-functions/hex.md)
* [HOUR()](/docs/server/reference/sql-functions/date-time-functions/hour.md)
* [IF()](/docs/server/reference/sql-functions/control-flow-functions/if-function.md)
* [IFNULL()](/docs/server/reference/sql-functions/control-flow-functions/ifnull.md)
* [IN](/docs/server/reference/sql-structure/operators/comparison-operators/in.md)
* [INET\_ATON()](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/inet_aton.md)
* [INET\_NTOA()](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/inet_ntoa.md)
* [INSERT()](/docs/server/reference/sql-functions/string-functions/insert-function.md)
* [INSTR()](/docs/server/reference/sql-functions/string-functions/instr.md)
* [ISNULL()](/docs/server/reference/sql-structure/operators/comparison-operators/isnull.md)
* [LAST\_DAY()](/docs/server/reference/sql-functions/date-time-functions/last_day.md)
* [LCASE()](/docs/server/reference/sql-functions/string-functions/lcase.md)
* [LEAST()](/docs/server/reference/sql-structure/operators/comparison-operators/least.md)
* [LEFT()](/docs/server/reference/sql-functions/string-functions/left.md)
* [LENGTH()](/docs/server/reference/sql-functions/string-functions/length.md)
* [LIKE](/docs/server/reference/sql-functions/string-functions/like.md)
* [LN()](/docs/server/reference/sql-functions/numeric-functions/ln.md)
* [LOCATE()](/docs/server/reference/sql-functions/string-functions/locate.md)
* [LOG()](/docs/server/reference/sql-functions/numeric-functions/log.md)
* [LOG2()](/docs/server/reference/sql-functions/numeric-functions/log2.md)
* [LOG10()](/docs/server/reference/sql-functions/numeric-functions/log10.md)
* [LOWER()](/docs/server/reference/sql-functions/string-functions/lower.md)
* [LPAD()](/docs/server/reference/sql-functions/string-functions/lpad.md)
* [LTRIM()](/docs/server/reference/sql-functions/string-functions/ltrim.md)
* [MAKEDATE()](/docs/server/reference/sql-functions/date-time-functions/makedate.md)
* [MAKETIME()](/docs/server/reference/sql-functions/date-time-functions/maketime.md)
* [MD5()](/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/md5.md)
* [MICROSECOND()](/docs/server/reference/sql-functions/date-time-functions/microsecond.md)
* [MINUTE()](/docs/server/reference/sql-functions/date-time-functions/minute.md)
* [MOD()](/docs/server/reference/sql-functions/numeric-functions/mod.md)
* [MONTH()](/docs/server/reference/sql-functions/date-time-functions/month.md)
* [MONTHNAME()](/docs/server/reference/sql-functions/date-time-functions/monthname.md)
* [NOW()](/docs/server/reference/sql-functions/date-time-functions/now.md)
* [NULLIF()](/docs/server/reference/sql-functions/control-flow-functions/nullif.md)
* [PERIOD\_ADD()](/docs/server/reference/sql-functions/date-time-functions/period_add.md)
* [PERIOD\_DIFF()](/docs/server/reference/sql-functions/date-time-functions/period_diff.md)
* [POSITION()](/docs/server/reference/sql-functions/string-functions/position.md)
* [POW()](/docs/server/reference/sql-functions/numeric-functions/pow.md), [POWER()](/docs/server/reference/sql-functions/numeric-functions/power.md)
* [QUARTER()](/docs/server/reference/sql-functions/date-time-functions/quarter.md)
* [RADIANS()](/docs/server/reference/sql-functions/numeric-functions/radians.md)
* [RAND()](/docs/server/reference/sql-functions/numeric-functions/rand.md)
* [REGEXP()](/docs/server/reference/sql-functions/string-functions/regular-expressions-functions/regexp.md)
* [REPEAT()](/docs/server/reference/sql-functions/string-functions/repeat-function.md)
* [REPLACE()](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/replace.md)
* [REVERSE()](/docs/server/reference/sql-functions/string-functions/reverse.md)
* [RIGHT()](/docs/server/reference/sql-functions/string-functions/right.md)
* [RLIKE()](/docs/server/reference/sql-functions/string-functions/regular-expressions-functions/rlike.md)
* [ROUND()](/docs/server/reference/sql-functions/numeric-functions/round.md)
* [RPAD()](/docs/server/reference/sql-functions/string-functions/rpad.md)
* [RTRIM()](/docs/server/reference/sql-functions/string-functions/rtrim.md)
* [SEC\_TO\_TIME()](/docs/server/reference/sql-functions/date-time-functions/sec_to_time.md)
* [SECOND()](/docs/server/reference/sql-functions/date-time-functions/second.md)
* [SHA(), SHA1()](/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/sha1.md)
* [SIGN()](/docs/server/reference/sql-functions/numeric-functions/sign.md)
* [SIN()](/docs/server/reference/sql-functions/numeric-functions/sin.md)
* [SPACE()](/docs/server/reference/sql-functions/string-functions/space.md)
* [SQRT()](/docs/server/reference/sql-functions/numeric-functions/sqrt.md)
* [STR\_TO\_DATE()](/docs/server/reference/sql-functions/date-time-functions/str_to_date.md)
* [STRCMP()](/docs/server/reference/sql-functions/string-functions/strcmp.md)
* [SUBDATE()](/docs/server/reference/sql-functions/date-time-functions/subdate.md)
* [SUBSTR()](/docs/server/reference/sql-functions/string-functions/substr.md), [SUBSTRING()](/docs/server/reference/sql-functions/string-functions/substring.md)
* [SUBSTRING\_INDEX()](/docs/server/reference/sql-functions/string-functions/substring_index.md)
* [SUBTIME()](/docs/server/reference/sql-functions/date-time-functions/subtime.md)
* [SYSDATE()](/docs/server/reference/sql-functions/date-time-functions/sysdate.md)
* [TAN()](/docs/server/reference/sql-functions/numeric-functions/tan.md)
* [TIME()](/docs/server/reference/data-types/date-and-time-data-types/time.md)
* [TIME\_FORMAT()](/docs/server/reference/sql-functions/date-time-functions/time_format.md)
* [TIME\_TO\_SEC()](/docs/server/reference/sql-functions/date-time-functions/time_to_sec.md)
* [TIMEDIFF()](/docs/server/reference/sql-functions/date-time-functions/timediff.md)
* [TIMESTAMPADD()](/docs/server/reference/sql-functions/date-time-functions/timestampadd.md)
* [TIMESTAMPDIFF()](/docs/server/reference/sql-functions/date-time-functions/timestampdiff.md)
* [TO\_DAYS()](/docs/server/reference/sql-functions/date-time-functions/to_days.md)
* [TRIM()](/docs/server/reference/sql-functions/string-functions/trim.md)
* [TRUNCATE()](/docs/server/reference/sql-functions/numeric-functions/truncate.md)
* [UCASE()](/docs/server/reference/sql-functions/string-functions/ucase.md)
* [UNIX\_TIMESTAMP()](/docs/server/reference/sql-functions/date-time-functions/unix_timestamp.md)
* [UNIX\_TIME()](/docs/server/reference/sql-functions/date-time-functions/unix_timestamp.md)
* [UPPER()](/docs/server/reference/sql-functions/string-functions/upper.md)
* [WEEK()](/docs/server/reference/sql-functions/date-time-functions/week.md)
* [WEEKDAY()](/docs/server/reference/sql-functions/date-time-functions/weekday.md)
* [WEEKOFYEAR()](/docs/server/reference/sql-functions/date-time-functions/weekofyear.md)
* [XOR()](/docs/server/reference/sql-structure/operators/logical-operators/xor.md)
* [YEAR()](/docs/server/reference/sql-functions/date-time-functions/year.md)
* [YEARWEEK()](/docs/server/reference/sql-functions/date-time-functions/yearweek.md)

## See Also

* [ColumnStore Non-Distributed Post-Processed Functions](/docs/analytics/mariadb-columnstore/reference/columnstore-non-distributed-post-processed-functions.md)

<sub>*This page is: Copyright © 2025 MariaDB. All rights reserved.*</sub>

{% @marketo/form formId="4316" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-distributed-functions.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.