> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/columnstore/reference/columnstore-distributed-functions.md).

# ColumnStore Distributed Functions

MariaDB ColumnStore distributed functions for SELECT, WHERE, and ORDER BY clauses: numeric, string, date/time, and bitwise operators processed in parallel across PrimProc nodes.

## 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.

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

## See Also

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

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

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