Home | About | Sematext search-lucene.com search-hadoop.com
 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