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 |