MySQL to Apache Hive Migration

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

  • SQLines SQL Converter - SQL scripts assessment and conversion tool

Databases:

  • MySQL 8.x and 5.x
  • Apache Hive 3.x and 2.x

MySQL to Hive Migration Reference

Technical information on migration from MySQL to Apache Hive.

CREATE TABLE Statement

Converting CREATE TABLE statement keywords and clauses:

MySQL Hive
1 COMMENT 'text' Column comment COMMENT 'text'