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,
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 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 upda
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 mailto:hadooph...@gmail.com>>
Reply-To: mailto:user@hi
