按照每日,省份统计pv和uv,date province UV PV
- 建立hive数据库及数据表
2.数据导入
- 建hive的db_track.daily_province_visit的表
导入
insert into table db_track.daily_province_visit select date, province, count(url) pv, count(distinct guid) uv from db_track.track_log where date = '20150828' group by date, province;
查看结果
- 建立mysql表
- Sqoop导入到mysql表
Mysql表的结果: