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,"\\.")[1] as int) as second,
cast(split(id,"\\.")[2] as int) as third
from
test_3)t1)t2
where rn=1

如有不对,请指正