create table table1 as with tmp as (select * from table2…) select * from tmp; 直接通过临时表+create table 方式来落地的hive语句;