测试用sql(用户连续活跃区间记录表)
需求:
1.1、T-1日(10.11) 区间表
create table act_range(
guid string,
first_dt string,
rng_start string,
rng_end string
)
partitioned by (dt string)
row format delimited fields terminated by ','
;
1.2、数据
vi rng.11
a,2020-10-01,2020-10-01,2020-10-03
原创
2020-10-13 21:27:19 ·
567 阅读 ·
0 评论