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.
When creating patterns for your migration, note the following:
If using Hive 3: Only use patterns with the wildcards
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
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.
On the Overview page, select Create a 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 Create to start the metadata migration.
Create a metadata migration with the CLI
Migrate metadata from your source metastore to a target metastore using the
hive migration command.
Follow the command links to learn how to set the parameters and see examples.