ALTER TABLE <table> SET TBLPROPERTIES('EXTERNAL'='TRUE');
It worked for me.
On Mon, Aug 6, 2012 at 11:08 PM, Babe Ruth <[EMAIL PROTECTED]>wrote:
> 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?