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
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.