Date and Time functions
DATE_ADD, DATE_SUB, DATEDIFF, DAYOFMONTH, FROM_UTC_TIMESTAMP, HOUR, MINUTE, MONTH, NOW, SECOND, TO_DATE, TO_UTC_TIMESTAMP, WEEKOFYEAR, YEAR, QUARTER
Conversion functions
SN
Math functions
ABS, ACOS, ASIN, ATAN, BIN, CEIL, CEILING, COS, DEGREES, E, EXP, HEX, LOG, LOG10, LN, LOG2, NEGATIVE, PI, PMOD, POSITIVE, POW, POWER, QUOTIENT, RADIANS, RAND, ROUND, SIGN, SIN, SQRT, TAN, UNHEX
Operators
%, -, +, *, /
Statistical functions
SUM, AVG, MIN, MAX, COUNT
Text functions
ASCII, CONCAT, CONCAT_WS, INSTR, LENGTH, LOCATE, LOWER, LCASE, LTRIM, REGEXP_EXTRACT, REGEXP_REPLACE, REVERSE, RTRIM, TRIM, UPPER, UCASE
The following functions are also supported, but with a lower performance:
SPACE, RPAD, LPAD, REPEAT, SUBSTR, SUBSTRING
Non-supported functions
Note that a few functions may be shown in the analysis even though they are not supported by the connector: INITCAP, TRANSLATE, CONV, GREATEST, LEAST, DAYNAME, DAYOFWEEK
Binning is not supported by this connector.