![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
hive
文章平均质量分 72
shui_dong
这个作者很懒,什么都没留下…
展开
-
hive基本操作2
//a) 统计WIFI环境下用户最多的5个城市 select city_code,count(access) as cnt from user where access=’WIFI’ group by city_code order by cnt desc limit 5;//b) 统计用户数>=3的access和city_code组合 select collect_set(uid)原创 2017-09-16 21:11:15 · 233 阅读 · 0 评论 -
hive基本操作1
select * from city order by city_code desc limit 10;select province_name,count(city_name) as cnt from city group by province_name order by cnt desc limit 10;select count(distinc(province_name)) from c原创 2017-09-16 21:12:06 · 230 阅读 · 0 评论 -
内表 外表区别 以及静态分区和动态分区
//内表 和外表的区分 删外表 表下的东西还在 内表相反 CREATE EXTERNAL TABLE CITY_ex( province_code int, province_name string, city_code int, city_name string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’ LINES TER原创 2017-09-16 20:13:34 · 1434 阅读 · 0 评论