Thanks Igor! It worked!
Date: Mon, 6 Aug 2012 23:26:04 -0700
Subject: Re: Changing table types from managed to external
From: [email protected]
To: [email protected]
CC: [email protected]
TryALTER TABLE <table> SET TBLPROPERTIES('EXTERNAL'='TRUE');
It worked for me.
igordecide.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
