cloudera - 在 Impala 中实现 CREATE AS SELECT

Question

请帮助我了解如何实现 CREATE TABLE AS SELECT

对于简单的create table t1 as select * from t2 ;我可以实现为

Create table t1 like t2;<br/>
insert into t1 as select * from t2;

但是如何实现create table t1 as select c1,c2,c3 from t2;

有没有办法在impala中实现这个？

Answer 1

正如评论中提到的，从 1.2 开始，Impala 支持 CREATE TABLE AS SELECT:documentation , JIRA ticket .