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.
If you are using MariaDB or MySQL, add the JDBC driver to the classpath manually.
Wildcards support
When creating patterns for your migration, note the following:
If using Hive 1, 2, or 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).
- UI
- CLI
Create a metadata migration with the UI
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.
From your Dashboard, select the product under Products.
Under Metadata Migrations, select Create metadata migration.
Enter a name for this migration.
Select a source and target agent.
Create a pattern that matches the databases and tables you want to migrate.
Select Start migration automatically to start the migration automatically or leave clear to start manually after creation.
Select Create to create the metadata migration.
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.
Create a metadata migration with the CLI
Migrate metadata from your source metastore to a target metastore using the hive migration
command.
Define the source and target using the hive agent names detailed in the Connect to metastores section, and apply the hive rule names to the migration.
Follow the command links to learn how to set the parameters and see examples.
Create a new metadata migration:
Apply the
--auto-start
parameter if you would like the migration to start right away.If you don't have auto-start enabled, manually start the migration: