The following are the functions that the Cloudera Impala connector supports.
Supported functions are the functions that you can use when you work with in-database data tables, for example for calculated columns and custom expressions.
Important: Some supported functions might not be possible to use with your database. This depends on what functions are available in the database, which often differs between database versions and types
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.