Migrations will transfer existing metadata, as well as any subsequent changes made to the source metadata (in its scope), while HiveMigrator keeps working.
If using MariaDB or MSSQL, the JDBC driver must be manually added to the classpath.
Ensure that you have migrated the HCFS data for the databases and tables that you want to migrate.
Both HCFS data and associated metadata are needed before successful queries can be run on migrated databases.
On the dashboard, select to add a Hive migration.
Provide a name for this migration.
Create a database pattern and a table pattern based upon Hive DDL that will match the databases and tables you want to migrate.
For example, using
test*for the database pattern will match any database with "test" at the beginning of its name, such as
Click Create to start the metadata migration with the parameters provided.
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.