1、有十万个淘宝店铺,每个顾客访问任意一个店铺时都会生成一条日志,访问日志存储表为visit,其中访问用户ID字段名称为uid,访问店铺的字段名称为store,请统计每个店铺的uv
select store,count(distanct uid) as uv from visit group by store;
2、有一亿个用户,被存储在表User中,其中用户唯一字段Uid,用户年龄age和用户消费总消费金额total,按照年龄从大到小进行排序,如果年龄相同,则按照总消费金额从小到大排序
select * from user order by age desc, total
3、行转列
goods_id
1,2,3,4,5,5,6
select expode(split(goods_id,",")) as goods_id from table;
4、持续更新中……