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.

• &
• ABS()
• ACOS()
• ADDDATE()
• ADDTIME()
• ASCII()
• ASIN()
• ATAN()
• BETWEEN...AND...
• BIT_AND()
• BIT_OR()
• BIT_XOR()
• CASE()
• CAST()
• CEIL(), CEILING()
• CHAR_LENGTH(), CHARACTER_LENGTH()
• COALESCE()
• CONCAT()
• CONCAT_WS()
• CONV()
• CONVERT()
• COS()
• COT()
• CRC32()
• DATE()
• DATE_ADD()
• DATE_FORMAT()
• DATE_SUB()
• DATEDIFF()
• DAY(), DAYOFMONTH()
• DAYNAME()
• DAYOFWEEK()
• DAYOFYEAR()
• DEGREES()
• DIV
• ELT()
• EXP()
• EXTRACT()
• FIND_IN_SET()
• FLOOR()
• FORMAT()
• FROM_DAYS()
• FROM_UNIXTIME()
• GET_FORMAT()
• GREATEST()
• GROUP_CONCAT()
• HEX()
• HOUR()
• IF()
• IFNULL()
• IN
• INET_ATON()
• INET_NTOA()
• INSERT()
• INSTR()
• ISNULL()
• LAST_DAY()
• LCASE()
• LEAST()
• LEFT()
• LENGTH()
• LIKE
• LN()
• LOCATE()
• LOG()
• LOG2()
• LOG10()
• LOWER()
• LPAD()
• LTRIM()
• MAKEDATE()
• MAKETIME()
• MD5()
• MICROSECOND()
• MINUTE()
• MOD()
• MONTH()
• MONTHNAME()
• NOW()
• NULLIF()
• PERIOD_ADD()
• PERIOD_DIFF()
• POSITION()
• POW(), POWER()
• QUARTER()
• RADIANS()
• RAND()
• REGEXP()
• REPEAT()
• REPLACE()
• REVERSE()
• RIGHT()
• RLIKE()
• ROUND()
• RPAD()
• RTRIM()
• SEC_TO_TIME()
• SECOND()
• SHA(), SHA1()
• SIGN()
• SIN()
• SPACE()
• SQRT()
• STR_TO_DATE()
• STRCMP()
• SUBDATE()
• SUBSTR(), SUBSTRING()
• SUBSTRING_INDEX()
• SUBTIME()
• SYSDATE()
• TAN()
• TIME()
• TIME_FORMAT()
• TIME_TO_SEC()
• TIMEDIFF()
• TIMESTAMPADD()
• TIMESTAMPDIFF()
• TO_DAYS()
• TRIM()
• TRUNCATE()
• UCASE()
• UNIX_TIMESTAMP()
• UNIX_TIME()
• UPPER()
• WEEK()
• WEEKDAY()
• WEEKOFYEAR()
• XOR()
• YEAR()
• YEARWEEK()

See also

• ColumnStore Non-Distributed Post-Processed Functions