Transferring hive table from one database to another

hive, hiveql

Solution

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.

Problem

Original source