Pls help me on how to implement CREATE TABLE AS SELECT
For simple create table t1 as select * from t2
; I can implement as
Create table t1 like t2;
insert into t1 as select * from t2;
But how to implement create table t1 as select c1,c2,c3 from t2;
Is there any way to implement this in impala?
As mentioned in the comments, CREATE TABLE AS SELECT is supported in Impala since 1.2: documentation, JIRA ticket.