Skip to content

Latest commit

 

History

History
20 lines (16 loc) · 458 Bytes

File metadata and controls

20 lines (16 loc) · 458 Bytes

数据架构案例

1. 10亿用户量,连续7天登录的用户标签该怎么打?

建表,并导入测试数据

drop table if exists user_login_log;
create table user_login_log(
name string, 
province string, 
login_date string,
login_time string
)
row format
delimited fields terminated by '\t'
stored as textfile;

参考文档:https://mp.weixin.qq.com/s/0bEbeBlVUbeJ__wYyv1eKw