hive之连续考题

1.有一个阅读情况表，表记录各小时read_hour，及对应阅读是否高峰flag（1是0否），统计出连续时段对应的峰值情况。数据如下，

   处理成 

解析思路：使用row_number()over开窗，按峰值情况分组并生成自增序列rowid，再按（小时数-rowid）分组计算对应时段内最小及最大小时即可

SQL如下，

select min(read_hour),max(read_hour),flag
from 
(
select read_hour
,row_number() over(partition by flag order by read_hour) as rowid,flag
from 
(

select 0 as read_hour,0 as flag union all
select 1 as read_hour,0 as flag union all
select 2 as read_hour,0 as flag union all
select 3 as read_hour,0 as flag union all
select 4 as read_hour,1 as flag union all
select 5 as read_hour,1 as flag union all
select 6 as read_hour,1 as flag union all
select 7