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
