Skip to main content
Version: 1.22.0

Create a metadata migration

Metadata migrations transfer existing metadata, as well as any subsequent changes made to the source metadata (in the scope of the migration), while Hive Migrator keeps working.

caution

If you are using MariaDB or MySQL, add the JDBC driver to the classpath manually.

note

Wildcards support
When creating patterns for your migration, note the following:

  • If using Hive 3: Only use patterns with the wildcards * and |.

    For example, using --database-pattern test* will match any database with "test" at the beginning of its name, such as test01, test02, test03.

  • If using Hive 4: Use any wildcards based on Hive's Data Definition Language (DDL).

Create a metadata migration with the UI

info

Ensure you have migrated the data for the databases and tables you want to migrate.

You need both the data and associated metadata before you can successfully run queries on migrated databases.

  1. On the Overview page, select Create a metadata migration.

  2. Enter a name for this migration.

  3. Select a source and target agent.

  4. Create a pattern that matches the databases and tables you want to migrate.

  5. Select Create to start the metadata migration.