一、题目:求连续7天登录的用户
1. 表结构:
create table `lotable`(
uid int,
dt string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|'
LINE TERMINATED BY '\n';
2. 用户表数据:
1|2022-07-11
1|2022-07-12
1|2022-07-13
1|2022-07-14
一、题目:求连续7天登录的用户
1. 表结构:
create table `lotable`(
uid int,
dt string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|'
LINE TERMINATED BY '\n';
2. 用户表数据:
1|2022-07-11
1|2022-07-12
1|2022-07-13
1|2022-07-14