Supported Functions

Date and Time functions

YEAR, QUARTER, MONTH, WEEK, WEEKOFYEAR, DAY, DAYOFMONTH, HOUR, MINUTE, SECOND, DATEDIFF, DATE_ADD

Conversion functions

Math functions

ABS, ACOS, ASIN, ATAN, BIN, CEIL, CEILING, COS, DEGREES, E, EXP, FLOOR, LN, LOG, LOG10, LOG2, NEGATIVE, PI, POW, POWER, POSITIVE, PMOD, RADIANS, RAND, ROUND, SIGN, SIN, SQRT, TAN

Operators

%, -, +, *, /

Statistical functions

SUM, AVG, MIN, MAX, COUNT, UNIQUECOUNT, VARIANCE, VAR_POP, VAR_SAMP, STDDEV_POP, STDDEV_SAMP, CORR, COVAR_POP, COVAR_SAMP, PERCENTILE

Text functions

CONCAT, INSTR, LENGTH, LOWER, LPAD, LTRIM, RPAD, RTRIM, TRIM, UPPER, LOCATE, REPEAT, SPACE, REGEXP_REPLACE, SUBSTR, SUBSTRING, REVERSE, FORMAT_NUMBER

Non-supported functions

Statistical functions:

HISTOGRAM_NUMERIC, COLLECT_SET, COLLECT_LIST

Date and Time functions:

FROM_UNIXTIME, UNIXTIMESTAMP, TO_DATE, DATE_SUB, FROM_UTC_TIMESTAMP, TO_UTC_TIMESTAMP

Text Functions:

ASCII, BASE64, CONTEXT_NGRAMS, CONCAT_WS, DECODE, ENCODE, FIND_IN_SET, GET_JSON_OBJECT, IN_FILE, NGRAMS, PARSE_URL, PRINTF, REGEXP_EXTRACT, SENTENCES, SPLIT, STR_TO_MAP, TRANSLATE, UNBASE64

Collection Functions, Type Conversion Functions, Conditional Functions, Misc. Functions and Table-Generating Functions are not supported in this version of the connector.