select v_id,
--版本号 max(split(v_id,".")[0]) v1,
--主版本不会为空 max(if(split(v_id,".")[1]="",0,split(v_id,".")[1]))v2,
--取出子版本并判断是否为空,并给默认值 max(if(split(v_id,".")[2]="",0,split(v_id,".")[2]))v3
--取出阶段版本并判断是否为空,并给默认值 from t1