hive案例 SQL题 连续登录的天数 连续命中次数 编号函数 row_numbew rank dense_rank
连续登录的天数数据如下:name login_datea,2020-11-01a,2020-11-05a,2020-11-04b,2020-11-04b,2020-11-05a,2020-11-03a,2020-11-02b,2020-11-08a,2020-11-07b,2020-11-01b,2020-11-02a,2020-11-06b,2020-11-061、创建表,导入数据create table login(name string ,login_date
原创
2020-12-03 21:02:56 ·
672 阅读 ·
0 评论