Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Changing table types from managed to external


+
Babe Ruth 2012-08-07, 06:08
Copy link to this message
-
Re: Changing table types from managed to external
Try
ALTER TABLE <table> SET TBLPROPERTIES('EXTERNAL'='TRUE');

It worked for me.

igor
decide.com

On Mon, Aug 6, 2012 at 11:08 PM, Babe Ruth <[EMAIL PROTECTED]>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
>
+
long 2012-08-07, 06:13
+
Jan Dolinár 2012-08-07, 06:21