-create external table as select with location?
Igor Tatarinov 2012-04-04, 17:33
Is it possible to do something like this:
CREATE EXTERNAL TABLE T
I would rather not fix the schema for T so that I can easily change the
SELECT query and its underlying tables.
Because of that, I don't want to define the table first. Instead, I have to
save the data into a temp table:
CREATE TABLE tmp AS
CREATE EXTERNAL TABLE T LIKE tmp
INSERT OVERWRITE TABLE T
SELECT * FROM tmp;
which seems to be slower than using a single INSERT with the original