t;
> From: Eva Tse
> Reply-To:
> Date: Thu, 18 Feb 2010 15:54:01 -0800
> To: , Zheng Shao , Paul Yang
>
> Subject: Re: Question on modifying a table to become external
>
>
> Prasad,
> That¹s what we are looking for.
> We tried both:
> * alter table add [propert
: Question on modifying a table to become external
Prasad,
That's what we are looking for.
We tried both:
* alter table add [properties|property] ('EXTERNAL' ='TRUE')
and it doesn't work. Could you give us the syntax where it would work?
Since it is not documented,
0800
> To: , Prasad Chakka , Paul
> Yang
> Subject: Re: Question on modifying a table to become external
>
> There is no command to do that right now.
>
> One way to go is to create another external table pointing to the same
> location (and forget about the old table).
>
d be possible to make it an external table.
I have not tried this so do it at your own risk :)
Prasad
From: Zheng Shao
Date: Thu, 18 Feb 2010 11:11:32 -0800
To: , Prasad Chakka , Paul
Yang
Subject: Re: Question on modifying a table to become external
There i
There is no command to do that right now.
One way to go is to create another external table pointing to the same
location (and forget about the old table).
Or you can move the files first, before dropping and recreating the same table.
Zheng
On Thu, Feb 18, 2010 at 10:22 AM, Eva Tse wrote:
>
> W
We created a table without the EXTERNAL¹ qualifier but did specify a
location for the warehouse. We would like to modify this to be an external
table. We tried to drop the table, but it does delete the files in the S3
external location.
Is there a way we could achieve this?
Thanks,
Eva.
CREAT
