hive连续登录问题

现在有一张用户消费信息表，求问连续三天登录用户有多少个，用户连续交易的总额、连续登陆天数、连续登陆开始和结束时间、间隔天数：

user_id bigint comment '广告主id',
daystr comment '日期'
price decimal(10,2) comment '消费金额'

数据预处理：

create table user_log_test (user_id int, daystr string, price decimal(10,2));
insert into user_log_test values
(1, "2019-12-08", 24.23), 
(1, "2019-12-08", 27.32), 
(1, "2019-12-09", 5.63), 
(1, "2019-12-09", 67.36), 
(1, "2019-12-10", 5.69), 
(1, "2019-12-12", 69.85), 
(1, "2019-12-13", 43.86), 
(1, "2019-12-14", 38.42),
(1, "2019-12-15", 69.76),
(1, "2019-12-16", 69.76),
(1, "2019-12-18", 95.15),
(1, "2019-12-19", 15.65),
(1, "2019-12-21", 37.71),
(2, "2019-12-08", 24.23), 
(2, "2019-12-08", 27.32), 
(2, "2019-12-09", 5.63), 
(2, "2019-12-09", 67.36), 
(2, "2019-12-