hive 一个表同时插入多个表

Question

这样写是可以运行的

from  table_all 
insert overwrite table table_1
select first where first=1
insert overwrite table table_2
select first where first=2

下面这种写法为什么不行， 应该怎么写

from  table_all 
create table table_1 as
select first where first=1
create table table_2 as
select first where first=2

会报错

Error: Error while compiling statement: FAILED: ParseException line 2:0 cannot recognize input near 'create' 'table'

Answer 1

目前是不行的