各位大佬,看看我的咋样,用hive写的 select t1.user_id ,t2.recent_login_date from ( select user_id , login_date , datediff(login_date ,lag(login_date) over(partition by user_id order by login_date ) ) as dt from user_login ) t1 left join (select max(login_date) recent_login_date,user_id from user_login group by user_id )t2 on t2.user_id = t1.user_id where t1.dt >=5
4 2

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务