hive多表插入，from后面接子查询，出问题

[HalaXiao___]

from (select * from ...) a,(select * from ....) b on (a.key=b.key)
insert.....
insert.....

上面的语句在hive执行的时候报错
求高手帮忙解决
是hive不支持这种类型的查询插入还是我的sql有问题

[mschen]

--try like this insert..... select ..... from (select * from ...) a join (select * from ....) b on (a.key=b.key);

[忆轩辕]

from 套一层看看 from (select * from (select * from ...) a,(select * from ....) b on (a.key=b.key)) t insert..... insert.....

[忆轩辕]

试试这个，上面join写得有问题 from (select * from (select * from ...) a inner join (select * from ....) b on a.key=b.key) t insert..... insert.....

[HalaXiao___]

引用 1 楼 mschen 的回复:

--try like this insert..... select ..... from (select * from ...) a join (select * from ....) b on (a.key=b.key);

你这个是单表的吧，我是指多表的插入 你的这种方法我在单表插入过，没有问题

[HalaXiao___]

这个貌似试过，明天我再试试看

[HalaXiao___]

引用 3 楼 colacat911 的回复:

from 套一层看看 from (select * from (select * from ...) a,(select * from ....) b on (a.key=b.key)) t insert..... insert.....

这个貌似试过，明天我再试试看

[yinan9]

把你完整的HQL放上来吧