RE: Changing table types from managed to external

2012-08-07 Thread Babe Ruth
de.com On Mon, Aug 6, 2012 at 11:08 PM, Babe Ruth 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

Changing table types from managed to external

2012-08-07 Thread Babe Ruth
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