SQL面试题-直播APP统计PV&UV

SQL面试题-直播APP统计PV&UV

hive> select * from temp;OK20180302 Page1 112 ios20180302 Page2 113 android20180303 Page1 117 ios20180303 Page2 117 ios20180304 Page3 138 androidTime taken: 0.222 seconds, Fetched: 5 row(s)hive> select `date`,count(uid) as pv,count(distinct uid) as uv from temp group by `date`;OK20180302 2 220180303 2 120180304 1 1Time taken: 7.692 seconds, Fetched: 3 row(s)

SQL如下

select `date`,count(uid) as pv,count(distinct uid) as uv from temp group by `date`;

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。