Is there a way to create an external table LIKE another table?

This doesn't work:

CREATE TABLE B LIKE A
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE
LOCATION 's3://..';

FAILED: Parse Error: line 2:0 mismatched input 'ROW' expecting EOF

I tried creating a managed table B first and then changing its properties.
I can "make" the table external but I don't know how to change its
"location" from hdfs to s3.

I am using EMR Hive.

Thanks!

igor
decide.com

1. create external table B like A;
2. alter table B set location 's3n://....'

Thanks,
Aniket

On Mon, Mar 5, 2012 at 4:59 PM, Igor Tatarinov <[EMAIL PROTECTED]> wrote:

> Is there a way to create an external table LIKE another table?
>
> This doesn't work:
>
> CREATE TABLE B LIKE A
> ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE
> LOCATION 's3://..';
>
> FAILED: Parse Error: line 2:0 mismatched input 'ROW' expecting EOF
>
> I tried creating a managed table B first and then changing its properties.
> I can "make" the table external but I don't know how to change its
> "location" from hdfs to s3.
>
> I am using EMR Hive.
>
> Thanks!
>
> igor
> decide.com
>
>
--
"...:::Aniket:::... Quetzalco@tl"

Thanks, I should have tried adding "external" before asking :)

Although, it doesn't work in EMR Hive. Table B is still 'described' as
managed so I had to run

alter table B set tblproperties('EXTERNAL'='TRUE');

along with changing the location.

Everything seems to work now!

On Mon, Mar 5, 2012 at 5:36 PM, Aniket Mokashi <[EMAIL PROTECTED]> wrote:

> 1. create external table B like A;
> 2. alter table B set location 's3n://....'
>
> Thanks,
> Aniket
>
>
> On Mon, Mar 5, 2012 at 4:59 PM, Igor Tatarinov <[EMAIL PROTECTED]> wrote:
>
>> Is there a way to create an external table LIKE another table?
>>
>> This doesn't work:
>>
>> CREATE TABLE B LIKE A
>> ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE
>> LOCATION 's3://..';
>>
>> FAILED: Parse Error: line 2:0 mismatched input 'ROW' expecting EOF
>>
>> I tried creating a managed table B first and then changing its
>> properties. I can "make" the table external but I don't know how to change
>> its "location" from hdfs to s3.
>>
>> I am using EMR Hive.
>>
>> Thanks!
>>
>> igor
>> decide.com
>>
>>
>
>
> --
> "...:::Aniket:::... Quetzalco@tl"
>