The Hadoop in Real World team shows how to move tables between databases in Hive:
Let’s see how to move a Hive table from one database to another in action.
We are currently inside a database named hirw. Let’s list the table under hirw.
We got one table named employee under database hirw. Let’s create a new database named hirw_2
Click through to see how.