计算用户的最大活跃日期间隔

有两种实践方式，第一种xf大神实现的，我采用该种方式
1、krill建表，取一个城市观察，南京，注册时间<11月，11月的用户活跃数，

CREATE table pri_da_risk.dmh_app_open_nj_11 as 
SELECT DISTINCT a1.passenger_id  
  ,a1.ds
FROM (SELECT passenger_id,ds
  FROM pub_cockpit_db.ods_user_app_open_detail 
  WHERE ds >= '20201101'
    AND ds <= '20201130'  
    AND client_id='1'
  ) a1
JOIN (SELECT passenger_uuid
  FROM pub_cockpit_db.dm_user_basic_char_dt 
  WHERE ds = '20201223'
          AND register_city = '320100'
    AND source = 't3app'
    AND register_time < '2020-10-01'
  ) a2
ON  a1.passenger_id = a2.passenger_uuid  
;

2、krill建表，对每条用户的每个活跃按照日期时间排序

CREATE TABLE dmh_app_open_rankid as
SELECT passenger_id
  ,ds
  ,from_unixtime(unix_timestamp(ds,'yyyyMMdd'