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 SET TBLPROPERTIES('EXTERNAL'='TRUE');
It worked for me.
igo
Try
ALTER TABLE SET TBLPROPERTIES('EXTERNAL'='TRUE');
It worked for me.
igor
decide.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
Hi George,
You can save yourself one copying. Just create a new external table with
different name, fill it with data (either by copying or query like INSERT
OVERWRITE DIRECTORY '/new/table/path' SELECT * FROM oldtable), drop the old
one and then rename the new one to the desired name:
ALTER TABL
