hive sql 查询最大版本号问题(面试题)
有如下版本号
要求求出最大的版本号
select
id
from
(
select
id,
dense_rank() over(order by first desc ,second desc,third desc) as rn
from
(select
id,
cast(split(id,"\\.")[0] as int) as first,
cast(split(id,"\\.")...
原创
2019-08-27 11:25:49 ·
1498 阅读 ·
0 评论