Someone recently posted a command to convert a managed table to an external table. If you also use that command, there's no expensive copy operation.
You'd probably want to move the data into a different HDFS directory though, to keep your namespace as consistent as possible, Matt On Jan 30, 2012, at 8:48 PM, Sriram Krishnan <skrish...@netflix.com> wrote: > You could do that if you don't mind moving the data (which may be expensive > depending on how much data you have). Also if your table is partitioned, you > may have to do another additional step (to recover partitions). > > Sriram > > From: Aniket Mokashi <aniket...@gmail.com> > Reply-To: <user@hive.apache.org> > Date: Mon, 30 Jan 2012 16:32:03 -0800 > To: <user@hive.apache.org> > Subject: Re: move tables into different database > > 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"
