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 MSSQL, add the JDBC driver to the classpath manually.
Ensure you have migrated the HCFS data for the databases and tables you want to migrate.
You need both HCFS data and associated metadata before you can run queries on migrated databases successfully.
On the Overview page, select Create a metadata migration.
Enter a name for this migration.
Select a source and target agent.
Create patterns that match the databases and tables you want to migrate. Wildcards in the patterns can only use
*for character(s) or
|for multiple patterns. For example,
test*for a database pattern matches any database with "test" at the beginning of its name, such as
testdata. The pattern
provenance*|*metadatamatches names beginning with
provenanceand or ending in
metadata. Do not use the following reserved database names for the database pattern:
Select Create to start the metadata migration.
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.