hive sql多表操作 秒懂否
--粉丝复购率(粉丝一定时间内第二次购买人数 与 支付用户比值 以天为维度)
select
w.uid,
cast(avg(w.datacount) * 100 / sum(w.totalcount) as int) as data_value,
from
(select z.uid as uid,z.datacount as datacount ,x.totalcount as to...
原创
2019-06-18 16:00:07 ·
839 阅读 ·
0 评论