Hive union all 性能测试

最新推荐文章于 2024-07-15 03:46:35 发布

hooyang

最新推荐文章于 2024-07-15 03:46:35 发布

阅读量223

点赞数

分类专栏： hive

本文链接：https://blog.csdn.net/hooyang/article/details/102463917

版权

hive 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

结论说明：待补充

insert overwite table tablename partition (dt= ....) 　
select ..... from ( 
select ... from A where ... 
union all 　
select ... from B where ... 
union all 
select ... from C  where ... ) R group by ...

生成job个数：待补充。用时：待补充

insert overwite table tablename partition (dt= ....) 　
select ... from A where ... group by ...
union all 　
select ... from B where ... group by ...
union all 
select ... from C  where ... group by ...

生成job个数：待补充。用时：待补充

insert into table tablename partition (dt= ....) select .... from A WHERE ... group by ...; 
insert into table tablename partition (dt= ....) select .... from B WHERE ... group by ...; 
insert into table tablename partition (dt= ....) select .... from C WHERE ... group by ...;

生成job个数：待补充。用时：待补充