2021-05-14

有如下数据

huawei	1001	2017-02-10
icbc	1001	2017-02-10
huawei	1001	2017-02-10
apple	1001	2017-02-10
huawei	1001	2017-02-10
huawei	1002	2017-02-10
huawei	1002	2017-02-10
huawei	1001	2017-02-10
huawei	1003	2017-02-10
huawei	1004	2017-02-10
huawei	1005	2017-02-10
icbc	1002	2017-02-10
jingdong	1006	2017-02-10
jingdong	1003	2017-02-10
jingdong	1002	2017-02-10
jingdong	1004	2017-02-10
apple	1001	2017-02-10
apple	1001	2017-02-10
apple	1001	2017-02-10
apple	1002	2017-02-10
apple	1002	2017-02-10
apple	1005	2017-02-10
apple	1005	2017-02-10
apple	1006	2017-02-10

1.load数据

drop table if exists test_two;

create table test_two(
    shoop_name string COMMENT '店铺名称',
    user_id string COMMENT '用户id',
    visit_time string COMMENT '访问时间'
)
row format delimited fields terminated by '\t';

load data local inpath "/opt/module/hive/datas/test/2.txt" into table test_two ;

1)每个店铺的UV（访客数）

select
	shoop_name 店铺,
	count(*) counts 
from
	test_two
group by
	shoop_name
order by 
	counts desc;