mysql、hive常用查询

1、分组汇总并累计，累计问题都要使用不等条件的连接解决

 -- 分组汇总并累计hive版（因为hive不支持不等条件的关联，且不在分组键的列必须聚合）
select s2.nam,s2.mon,max(s2.sum1),SUM(s3.num) from
(SELECT s1.nam,s1.mon,SUM(num) sum1 FROM  xzq_temp s1 GROUP BY s1.nam,s1.mon)s2
inner JOIN 
(SELECT s1.nam,s1.mon,SUM(num) num FROM  xzq_temp s1 GROUP BY s1.nam,s1.mon) s3
on s2.nam=s3.nam
where s2.mon>=s3.mon

GROUP BY s2.nam,s2.mon,s2.sum1
ORDER BY s2.nam,s2.mon

=====》