sparksql优化1(小表大表关联优化 & union替换or)
----原语句(运行18min)INSERT into TABLE schema.dstable SELECT bb.ip FROM (SELECT ip, sum(click) click_num, round(sum(click)/sum(imp),4) user_click_rate FROM schema.srctable1WHERE date = '2017102
原创
2017-11-07 18:03:15 ·
6126 阅读 ·
0 评论