Skip to main content
Version: 2.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. From your Dashboard, select the product under Products.

  2. Under Metadata Migrations, select Create metadata migration.

  3. Enter a name for this migration.

  4. Select a source and target agent.

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

  6. Select Start migration automatically to start the migration automatically or leave clear to start manually after creation.

  7. Select Create to create the metadata migration.

info

Metrics shown on the metadata migration content summary page don’t show correct results following certain metadata migration failures. See the Known issue for more information.