hadoop hive 2012-01-30, 14:35
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).
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
Is this possible to moves table into different hive database??
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