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 <i...@decide.com> 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"
