Transferring hive table from one database to anoth

Question

I need to move a hive table from one database to another. How can I do that?

Answer 1

The database you want to migrate it would have provided you with a database connector. With the help of sqoop and the database connector, you could be able to migrate it. would be great if you are more specific about the type of database you want to migrate the data to

Answer 2

Since 0.14, you can use following statement to move table from one database to another in the same metastore:

use old_database;
alter table table_a rename to new_database.table_a

The above statements will also move the table data on hdfs if table_a is a managed table.