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 <gtevelde-h...@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 >