SQLines provides tools to help you convert database schema (DDL), views, queries and SQL scripts from Apache Hive to Trino and Presto.
Databases:
Converting functions:
| Hive | Trino | ||
| 1 | COLLECT_SET(col) | Aggregate unique row values to array | ARRAY_AGG(DISTINCT col) |