SQLines provides tools to help you convert database schema (DDL), views, queries and SQL scripts from Apache Hive to Snowflake.
Databases:
Converting datetime functions:
| Hive | Snowflake | ||
| 1 | FROM_UNIXTIME(epoch) | Get the timestamp from epoch seconds | TO_TIMESTAMP(epoch) |
Converting data type casting functions:
| Hive | Snowflake | ||
| 1 | INT(exp) | Convert to integer value | CAST(exp AS INT) |