Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> create table LIKE for external tables?


Copy link to this message
-
Re: create table LIKE for external tables?
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"
>