weixin_40668508的博客

原创 hive sql调优

1.使用multi-table-insert写法对union all进行优化 （1）原SQL（目标是往一个新表user_new里，插入最大值和最小值的数据） insert into table user_new select sex, max(age) as stat, 'max' as class from user group by sex union all select sex, min(age) as stat, 'min' as class from user group by sex; （2