Cloudera Impala Function Support
TDV supports the following types of functions for Cloudera Impala:
Cloudera Impala Numeric Function Support
TDV supports the numeric functions listed in the table below for Cloudera Impala.
Cloudera Impala Numeric Function | Notes |
ABS | |
ACOS | |
ASIN | |
ATAN | |
ATAN2 | |
COS | |
COSH | |
COT | |
EXP | |
FACTORIAL | |
FLOOR | |
MOD | |
GREATEST | |
TO_HEX | |
LEAST | |
LN | |
LOG | |
LOG10 | |
POW | |
RAND | |
RANDOM | |
ROUND | |
SIGN | |
SIN | |
SINH | |
SQRT | |
TAN | |
TANH | |
TRUNC | |
Cloudera Impala Aggregate Function Support
TDV supports the aggregate functions listed in the table below for Cloudera Impala.
Cloudera Impala Aggregate Function | Notes |
VARIANCE_SAMP | |
VARIANCE_POP | |
VARIANCE | |
STDDEV | |
STDDEV_SAMP | |
STDDEV_POP | |
EXTRACT | |
CAST | |
Cloudera Impala Date Function Support
TDV supports the date function listed in the table below for Cloudera Impala.
Cloudera Impala Date Function | Notes |
ADD_MONTHS | |
DATEDIFF | |
DAY | |
DAYNAME | |
DAYOFWEEK | |
DAYOFYEAR | |
HOUR | |
MONTHS_BETWEEN | |
SECOND | |
TO_DATE | |
TRUNC | |
EXTRACT | |
YEAR | |
Cloudera Impala Conditional Function Support
TDV supports the conditional functions listed in the table below for Cloudera Impala.
Cloudera Impala Conditional Function | Notes |
COALESCE | |
CASE | |
DECODE | |
IFNULL | |
ISNULL | |
NULLIF | |
NVL | |
Cloudera Impala Character Function Support
TDV supports the character functions listed in the table below for Cloudera Impala.
Cloudera Impala Character Function | Notes |
BTRIM | |
CHR | |
CONCAT | |
INITCAP | |
INSTR | |
LOCATE | |
REGEXP_LIKE | |
REVERSE | |
SPLIT_PART | |
TRANSLATE | |
Cloudera Impala Analytic Function Support
TDV supports the aggregate functions listed in the table below for Cloudera Impala.
Cloudera Impala Analytic Function | Notes |
CUME_DIST | |
DENSE_RANK | |
FIRST_VALUE | |
LAG | |
LAST_VALUE | |
LEAD | |
NTILE | |
PERCENT_RANK | |
RANK | |
ROW_NUMBER | |