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 >
