Snowpark Migration Accelerator: HiveSQL¶
Supported functions¶
Strings¶
Function |
Status |
|---|---|
CONCAT |
SUPPORTED |
CONCAT_WS |
SUPPORTED |
LOWER |
SUPPORTED |
LPAD |
SUPPORTED |
REVERSE |
SUPPORTED |
SUBSTR/SUBSTRING |
SUPPORTED |
TRANSLATE |
SUPPORTED |
TRIM |
SUPPORTED |
UPPER |
SUPPORTED |
Numerics¶
Function |
Status |
|---|---|
ABS |
SUPPORTED |
AVG |
SUPPORTED |
COUNT |
SUPPORTED |
DENSE_RANK |
SUPPORTED |
MAX |
SUPPORTED |
MIN |
SUPPORTED |
RANK |
SUPPORTED |
REGEXP_REPLACE |
SUPPORTED |
ROUND |
SUPPORTED |
SUM |
SUPPORTED |
Date¶
Function |
Status |
|---|---|
ADD_MONTHS |
SUPPORTED |
CURRENT_DATE |
SUPPORTED |
CURRENT_TIMESTAMP |
SUPPORTED |
DATE_ADD |
PENDING |
DATEDIFF |
PENDING |
DATE_FORMAT |
PENDING |
FIRST_VALUE |
PENDING |
FROM_UNIXTIME |
PENDING |
LAST_DAY |
SUPPORTED |
MONTH |
SUPPORTED |
TO_DATE |
SUPPORTED |
TO_UTC_TIMESTAMP |
PENDING |
UNIX_TIMESTAMP |
PENDING |
YEAR |
SUPPORTED |
Advanced functions¶
Function |
Status |
|---|---|
CAST |
SUPPORTED |
COALESCE |
SUPPORTED |
COLLECT_SET |
PENDING |
LAG |
SUPPORTED |
LEAD |
PENDING |
NVL |
SUPPORTED |
NTILE |
SUPPORTED |
PARTITION |
PENDING |
ROW_NUMBER |
SUPPORTED |
TRUNC |
PENDING |