Data Engineering Integration
All Products
Function
| Blaze Engine
| Spark Engine
| Hive Engine
|
---|---|---|---|
ABORT
| Not supported
| Not supported
| Not supported
|
AES_DECRYPT
| Supported
| Supported
| Supported
|
AES_ENCRYPT
| Supported
| Supported
| Supported
|
ANY
| Supported
| Supported with restrictions
| Supported with restrictions
|
AVG
| Supported
| Supported with restrictions
| Supported with restrictions
|
COMPRESS
| Supported
| Supported
| Supported
|
COUNT
| Supported
| Supported with restrictions
| Supported with restrictions
|
CRC32
| Supported
| Supported
| Supported
|
CREATE_TIMESTAMP_TZ
| Supported
| Not supported
| Not supported
|
CUME
| Not supported
| Not supported
| Not supported
|
DECOMPRESS
| Supported
| Supported with restrictions
| Supported
|
DEC_BASE64
| Supported
| Supported
| Supported
|
ENC_BASE64
| 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
|
MAX (Dates)
| Supported
| Supported
| Not supported
|
MAX (Numbers)
| Supported
| Supported with restrictions
| Supported with restrictions
|
MAX (String)
| Supported
| Supported with restrictions
| Supported with restrictions
|
MD5
| Supported
| Supported
| Supported
|
MIN (Dates)
| Supported
| Supported
| Not supported
|
MIN (Numbers)
| Supported
| Supported with restrictions
| Supported with restrictions
|
MIN (String)
| Supported
| Supported with restrictions
| Supported with restrictions
|
MOVINGAVG
| Not supported
| Not supported
| Not supported
|
MOVINGSUM
| Not supported
| Not supported
| Not supported
|
PERCENTILE
| Supported
| Supported with restrictions
| Supported with restrictions
|
STDDEV
| Supported
| Supported with restrictions
| Supported with restrictions
|
SUM
| Supported
| Supported with restrictions
| Supported with restrictions
|
SYSTIMESTAMP
| Supported
| Supported with restrictions
| Supported
|
TO_DECIMAL
| Supported
| Supported with restrictions
| Supported with restrictions
|
TO_DECIMAL38
| Supported
| Supported with restrictions
| Supported with restrictions
|
TO_TIMESTAMP_TZ
| Supported
| Not supported
| Supported
|
UUID4
| Supported
| Supported
| Supported with restrictions
|
UUID_UNPARSE
| Supported
| Supported
| Supported with restrictions
|
VARIANCE
| Supported
| Supported with restrictions
| Supported with restrictions
|
Functions not listed in this table are supported on all engines without restrictions. |
Updated July 03, 2018