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