Hive QL场景题第六部分详解

26、请使用sql计算pv、uv？

数据:

t1表

uid dt url
1 2019-08-06 http://www.baidu.com
2 2019-08-06 http://www.baidu.com
3 2019-08-06 http://www.baidu.com
3 2019-08-06 http://www.soho.com
3 2019-08-06 http://www.meituan.com
3 2019-08-06

结果如下:

dt uv pv 
2019-08-6 3 5 

create table user_net_log(
uid int,
dt date,
url string
)
row format delimited
fields terminated by ' ';
​
load data local inpath './hivedata/user_net_log.txt' overwrite into table user_net_log;

select dt,count(distinct uid) uv,count(url) pv
from user_net_log
group by dt;
​
rusule：
Total MapReduce CPU Time Spent: 0 msec
OK
NULL    1       0
2019-08-06      3       5
​

27、hive中coalease()、nvl()、concat_ws()、collect_list()、collect_set()、regexp_replace().这几个函 数的意义？

略

</