Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> move tables into different database


Copy link to this message
-
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 <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]>
> Reply-To: <[EMAIL PROTECTED]>
> Date: Mon, 30 Jan 2012 20:05:13 +0530
> To: <[EMAIL PROTECTED]>
> Subject: move tables into different database
>
>  Hey folks,
>
>  Is this possible to moves table into different hive database??
>
>  regards
> Vikas Srivastava
>
>
>
--
"...:::Aniket:::... Quetzalco@tl"