Migrating to Presto from Hive

To migrate from Hive to Presto, you need to use the SQL syntax and semantics that Presto supports as it uses ANSI SQL syntax and semantics. ANSI SQL has many differences from HiveQL, which is a query language that Hive uses.

During migration from Hive, you can use Qubole’s Presto UDFs open-source repository that contains Hive functions’ implementations.

For more information, see the open-source Presto documentation for migrating from Hive.