Thanks Igor! It worked!
Date: Mon, 6 Aug 2012 23:26:04 -0700
Subject: Re: Changing table types from managed to external
From: i...@decide.com
To: user@hive.apache.org
CC: d...@hive.apache.org
TryALTER TABLE <table> SET TBLPROPERTIES('EXTERNAL'='TRUE');
It worked for me.
igordecide.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
