If you are on hdfs How about--
use db1; create table table1 like db2.table1; and move the data? Thanks, Aniket On Mon, Jan 30, 2012 at 8:09 AM, Sriram Krishnan <skrish...@netflix.com>wrote: > 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> > Reply-To: <user@hive.apache.org> > Date: Mon, 30 Jan 2012 20:05:13 +0530 > To: <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 > > > -- "...:::Aniket:::... Quetzalco@tl"
