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 ·
1419 阅读 ·
0 评论