hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Babe Ruth <gtevelde-h...@hotmail.com>
Subject RE: Changing table types from managed to external
Date Tue, 07 Aug 2012 21:43:03 GMT



Thanks Igor!  It worked!

Date: Mon, 6 Aug 2012 23:26:04 -0700
Subject: Re: Changing table types from managed to external
From: igor@decide.com
To: user@hive.apache.org
CC: dev@hive.apache.org

TryALTER TABLE <table> SET TBLPROPERTIES('EXTERNAL'='TRUE');

It worked for me.
igordecide.com


On Mon, Aug 6, 2012 at 11:08 PM, Babe Ruth <gtevelde-hive@hotmail.com> wrote:





Hello,  I created a managed table in HIVE when i intended for it to be external, is it possible
for me to change the table back to external?
OR do I have to copy the data to a new directory, drop the table, then copy it back?


Thanks,George 		 	   		  

 		 	   		  
Mime
View raw message