Function | Blaze Engine | Spark Engine | Hive Engine |
|---|---|---|---|
ABORT | Not supported | Not supported | Not supported |
ANY | Supported | Supported | Supported |
ARRAY | Not supported | Supported | Not supported |
AVG | Supported | Supported | Supported |
CAST | Not supported | Supported | Not supported |
COLLECT_LIST | Not supported | Supported | Not supported |
COLLECT_MAP | Not supported | Supported | Not supported |
CONCAT_ARRAY | Not supported | Supported | Not supported |
COUNT | Supported | Supported | Supported |
CREATE_TIMESTAMP_TZ | Supported | Not supported | Not supported |
CUME | Not supported | Not supported | Not supported |
DECOMPRESS | Supported | Supported | Supported |
ERROR | Not supported | Not supported | Not supported |
FIRST | Not supported | Not supported | Not supported |
GET_TIMEZONE | Supported | Not supported | Not supported |
GET_TIMESTAMP | Supported | Not supported | Not supported |
LAST | Not supported | Not supported | Not supported |
LAG | Not supported | Supported | Not supported |
LEAD | Not supported | Supported | Not supported |
MAP | Not supported | Supported | Not supported |
MAP_FROM_ARRAYS | Not supported | Supported | Not supported |
MAP_KEYS | Not supported | Supported | Not supported |
MAP_VALUES | Not supported | Supported | Not supported |
MAX (Dates) | Supported | Supported | Not supported |
MAX (Numbers) | Supported | Supported | Supported |
MAX (String) | Supported | Supported | Supported |
METAPHONE | Supported | Supported | Supported |
MIN (Dates) | Supported | Supported | Not supported |
MIN (Numbers) | Supported | Supported | Supported |
MIN (String) | Supported | Supported | Supported |
MOVINGAVG | Not supported | Not supported | Not supported |
MOVINGSUM | Not supported | Not supported | Not supported |
PERCENTILE | Supported | Supported | Supported |
RESPEC | Not supported | Supported | Not supported |
SIZE | Not supported | Supported | Not supported |
STDDEV | Supported | Supported | Supported |
STRUCT | Not supported | Supported | Not supported |
STRUCT_AS | Not supported | Supported | Not supported |
SUM | Supported | Supported | Supported |
SYSTIMESTAMP | Supported | Supported | Supported |
TO_DATE | Supported | Supported | Supported |
TO_DECIMAL | Supported | Supported | Supported |
TO_DECIMAL38 | Supported | Supported | Supported |
TO_TIMESTAMP_TZ | Supported | Not supported | Supported |
UUID4 | Supported | Supported | Supported |
UUID_UNPARSE | Supported | Supported | Supported |
VARIANCE | Supported | Supported | Supported |