Hive Table Migration

Apache Hive supports ORC, Parquet file formats that could be migrated to Paimon. When migrating data to a paimon table, the origin table will be permanently disappeared. So please back up your data if you still need the original table. The migrated table will be append table.

Now, we can use paimon hive catalog with Migrate Table Procedure and Migrate File Procedure to totally migrate a table from hive to paimon. At the same time, you can use paimon hive catalog with Migrate Database Procedure to fully synchronize all tables in the database to paimon.

  • Migrate Table Procedure: Paimon table does not exist, use the procedure upgrade hive table to paimon table. Hive table will disappear after action done.
  • Migrate Database Procedure: Paimon table does not exist, use the procedure upgrade all hive tables in database to paimon table. All hive tables will disappear after action done.
  • Migrate File Procedure: Paimon table already exists, use the procedure to migrate files from hive table to paimon table. Notice that, Hive table will also disappear after action done.

These three actions now support file format of hive “orc” and “parquet” and “avro”.

We highly recommend to back up hive table data before migrating, because migrating action is not atomic. If been interrupted while migrating, you may lose your data.

Example for Migration

Migrate Hive Table

Command:

CALL sys.migrate_table(‘hive’, ‘<hive_database>.<hive_tablename>’, ‘<paimon_tableconf>’);

Example

  1. CREATE CATALOG PAIMON WITH ('type'='paimon', 'metastore' = 'hive', 'uri' = 'thrift://localhost:9083', 'warehouse'='/path/to/warehouse/');
  3. USE CATALOG PAIMON;
  5. CALL sys.migrate_table('hive', 'default.hivetable', 'file.format=orc');

After invoke, “hivetable” will totally convert to paimon format. Writing and reading the table by old “hive way” will fail. We can add our table properties while importing by sys.migrate_table(‘.’, ‘’). here should be separated by “,”. For example:

  1. CALL sys.migrate_table('hive', 'my_db.wait_to_upgrate', 'file.format=orc,read.batch-size=2096,write-only=true')

If your flink version is below 1.17, you can use flink action to achieve this:

  1. <FLINK_HOME>/bin/flink run \
  2. /path/to/paimon-flink-action-0.9.0.jar \
  3. migrate_table
  4. --warehouse <warehouse-path> \
  5. --source_type hive \
  6. --table <database.table-name> \
  7. [--catalog_conf <paimon-catalog-conf> [--catalog_conf <paimon-catalog-conf> ...]] \
  8. [--options <paimon-table-conf  [,paimon-table-conf ...]> ]

Example:

  1. <FLINK_HOME>/flink run ./paimon-flink-action-0.9.0.jar migrate_table \
  2. --warehouse /path/to/warehouse \
  3. --catalog_conf uri=thrift://localhost:9083 \
  4. --catalog_conf metastore=hive \
  5. --source_type hive \
  6. --table default.hive_or_paimon \

Migrate Hive Database

Command:

CALL sys.migrate_database(‘hive’, ‘<hive_database>’, ‘<paimon_tableconf>’);

Example

  1. CREATE CATALOG PAIMON WITH ('type'='paimon', 'metastore' = 'hive', 'uri' = 'thrift://localhost:9083', 'warehouse'='/path/to/warehouse/');
  3. USE CATALOG PAIMON;
  5. CALL sys.migrate_database('hive', 'default', 'file.format=orc');

After invoke, all tables in “default” database will totally convert to paimon format. Writing and reading the table by old “hive way” will fail. We can add our table properties while importing by sys.migrate_database(‘’, ‘’). here should be separated by “,”. For example:

  1. CALL sys.migrate_database('hive', 'my_db', 'file.format=orc,read.batch-size=2096,write-only=true')

If your flink version is below 1.17, you can use flink action to achieve this:

  1. <FLINK_HOME>/bin/flink run \
  2. /path/to/paimon-flink-action-0.9.0.jar \
  3. migrate_databse
  4. --warehouse <warehouse-path> \
  5. --source_type hive \
  6. --database <database> \
  7. [--catalog_conf <paimon-catalog-conf> [--catalog_conf <paimon-catalog-conf> ...]] \
  8. [--options <paimon-table-conf  [,paimon-table-conf ...]> ]

Example:

  1. <FLINK_HOME>/flink run ./paimon-flink-action-0.9.0.jar migrate_table \
  2. --warehouse /path/to/warehouse \
  3. --catalog_conf uri=thrift://localhost:9083 \
  4. --catalog_conf metastore=hive \
  5. --source_type hive \
  6. --database default \

Migrate Hive File

Command:

CALL sys.migrate_file(‘hive’, ‘<hive_database>.<hive_table_name>’, ‘<paimon_database>.<paimon_tablename>’);

Example

  1. CREATE CATALOG PAIMON WITH ('type'='paimon', 'metastore' = 'hive', 'uri' = 'thrift://localhost:9083', 'warehouse'='/path/to/warehouse/');
  3. USE CATALOG PAIMON;
  5. CALL sys.migrate_file('hive', 'default.hivetable', 'default.paimontable');

After invoke, “hivetable” will disappear. And all files will be moved and renamed to paimon directory. “paimontable” here must have the same partition keys with “hivetable”, and “paimontable” should be in unaware-bucket mode.