AFAIK there is no way in HiveQL to do this. We had a similar requirement in the past, and we wrote a shell script to update the MySQL metastore directly (obviously not the cleanest or recommended way to go).
Cheers, Sriram From: hadoop hive <hadooph...@gmail.com<mailto:hadooph...@gmail.com>> Reply-To: <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Mon, 30 Jan 2012 20:05:13 +0530 To: <user@hive.apache.org<mailto:user@hive.apache.org>> Subject: move tables into different database Hey folks, Is this possible to moves table into different hive database?? regards Vikas Srivastava
