Home | About | Sematext search-lucene.com search-hadoop.com
 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
Sriram Krishnan 2012-01-30, 16:09
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