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: u...@hive.apache.org
CC: dev@hive.apache.org
TryALTER TABLE SET TBLPROPERTIES('EXTERNAL'='TRUE');
It worked for me.
igordeci
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
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
