定义
留存率:某日注册的用户,在之后几天是否活跃,一日留存率就是用户注册后第二天仍然活跃,以此类推,三日留存率,七日留存率。
任务:
计算所有用户注册后的一日留存率,三日留存率和七日留存率。
建表
use default;
show tables;
create table register_tbl(
user_id string,
register_date string)
row format delimited fields terminated by ','
location "/HiveTestDB/retention/re"
tblproperties("skip.header.line.count"="1");
create table active_tbl(
user_id string,
active_date string)
row format delimited fields terminated by ','
location "/HiveTestDB/retention/ac"
tblproperties("skip.hea