Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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"
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB