grate is
> tbl_name. I should note that this worked for us for Hive 0.7.1, and we were
> using a MySQL database for the metastore.
>
> Its certainly hacky, but did the job. Before you actually do the update
> in the last step, you may want to test it thoroughly :).
>
> Sriram
&g
y do the update in the
last step, you may want to test it thoroughly :).
Sriram
From: hadoop hive mailto:hadooph...@gmail.com>>
Reply-To: mailto:user@hive.apache.org>>
Date: Tue, 31 Jan 2012 11:19:14 +0530
To: mailto:user@hive.apache.org>>
Subject: Re: move tables into different database
Also if your table is
> partitioned, you may have to do another additional step (to recover
> partitions).
>
> Sriram
>
> From: Aniket Mokashi
> Reply-To:
> Date: Mon, 30 Jan 2012 16:32:03 -0800
> To:
> Subject: Re: move tables into different database
>
>
> Sriram
>
> From: Aniket Mokashi
> Reply-To:
> Date: Mon, 30 Jan 2012 16:32:03 -0800
> To:
> Subject: Re: move tables into different database
>
> If you are on hdfs
>
> How about--
>
> use db1;
> create table table1 like db2.table1;
>
> an
t;
Reply-To: mailto:user@hive.apache.org>>
Date: Mon, 30 Jan 2012 16:32:03 -0800
To: mailto: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,
ipt to update the MySQL metastore
> directly (obviously not the cleanest or recommended way to go).
>
> Cheers,
> Sriram
>
> From: hadoop hive
> Reply-To:
> Date: Mon, 30 Jan 2012 20:05:13 +0530
> To:
> Subject: move tables into different database
>
> Hey f
o:user@hive.apache.org>>
Date: Mon, 30 Jan 2012 20:05:13 +0530
To: 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
