Hive按特定时间窗口分组求和实例

样例数据：

         > select * from tmp.lanfz_log;
2020-09-14 13:47:12,771 [ForkJoinPool-1-worker-3] INFO  cn.jpush.spark.parser.SqlStatisticsParser - queryId : e1a036de-3463-4ab9-a3e9-9ba6e6229227
usera    lb    2020091410    60                                              
usera    la    2020091412    60
userb    la    2020091409    60
usera    la    2020091409    60
userb    la    2020091411    60
userb    lb    2020091410    60
usera    la    2020091408    60
usera    la    2020091407    30
usera    lb    2020091413    60
userb    la    2020091408    60
usera    la    2020091411    60
Time taken: 5.622 seconds, Fetched 11 row(s)
spark-sql>

sql