When you've connected your metastores, define the metadata rules that determine the metadata you want to migrate.
Ensure that you have migrated the data for the databases and tables that you want to migrate.
You need both the data and associated metadata before you can successfully run queries on migrated databases.
Define metadata rules with the UI
In the UI, metadata rules are defined when creating a metadata migration.
Define metadata rules with the CLI
Add metadata rules
Define which databases and tables you want to migrate by creating metadata rules.
Create a database pattern and a table pattern.
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
If using Hive 4: Use any wildcards based on Hive's Data Definition Language (DDL).
hive rule add,
hive rule create
|Create a metadata rule that can be used for a migration
Configure existing metadata rules
hive rule configure
|Configure an existing metadata rule
Manage metadata rules
hive rule delete
|Delete a metadata rule
hive rule list
|List all metadata rules
hive rule show
|Show the configuration of a metadata rule
Once you have defined the metadata rules, create a metadata migration.