Hive sql 任意N天中有M天登录，如 任意7天达到3天登录

使用HiveSQL实现 任意N天中有M天登录的需求：具体举例，***任意7天达到3天登录***
可以翻译为：当前次登录时间 与 第3次登陆的时间 的差值在7天内

WITH user_info as(
select 1 as user_id, '2020-01-01' as log_date union all
select 1 as user_id, '2020-01-02' as log_date union all
select 1 as user_id, '2020-01-03' as log_date union all
select 1 as user_id, '2020-01-04' as log_date union all

select 2 as user_id, '2020-01-01' as log_date union all
select 2 as user_id, '2020-01-06' as log_date union all