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 Plain View
Hive >> mail # user >> move tables into different database


+
hadoop hive 2012-01-30, 14:35
Copy link to this message
-
Re: move tables into different database
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]<mailto:[EMAIL PROTECTED]>>
Reply-To: <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Mon, 30 Jan 2012 20:05:13 +0530
To: <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Subject: move tables into different database

Hey folks,

Is this possible to moves table into different hive database??

regards
Vikas Srivastava
+
Aniket Mokashi 2012-01-31, 00:32
+
Sriram Krishnan 2012-01-31, 01:48
+
Matt Tucker 2012-01-31, 01:52
+
hadoop hive 2012-01-31, 05:49
+
Sriram Krishnan 2012-01-31, 06:47
+
hadoop hive 2012-01-31, 07:00
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