hive
weixin_45380205
这个作者很懒,什么都没留下…
展开
-
表中数据转表头信息--hql面试
由源表转为结果表select id,sub['数学'] as math,sub['语文'] as yuwen from (select id,str_to_map(concat_ws(",",collect_set(concat_ws(':', subject, cast(score as string))))) as subfromtest_1GROUP BY id)...原创 2019-08-25 10:17:32 · 146 阅读 · 0 评论 -
hive sql 查询最大版本号问题(面试题)
有如下版本号要求求出最大的版本号select idfrom (select id,dense_rank() over(order by first desc ,second desc,third desc) as rnfrom (select id,cast(split(id,"\\.")[0] as int) as first,cast(split(id,"\\.")...原创 2019-08-27 11:25:49 · 1449 阅读 · 0 评论