Apache Hive to Trino/Presto Migration

SQLines provides tools to help you convert database schema (DDL), views, queries and SQL scripts from Apache Hive to Trino and Presto.

  • SQLines SQL Converter - SQL scripts assessment and conversion tool


  • Apache Hive 3.x and 2.x
  • Presto/Trino any version

Hive to Trino/Presto Migration Reference

Built-in SQL Functions

Converting functions:

Hive Trino
1 COLLECT_SET(col) Aggregate unique row values to array ARRAY_AGG(DISTINCT col)