1. create external table B like A;
2. alter table B set location 's3n://....'
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.