#每天一点点,记录工作中实操可行#
hive 解析经纬度
解析经纬度字段 原始字段: POINT(116.094532 39.579501)
select city_name, num_id
,split(regexp_replace(open_position,'POINT\\(|\\)',''),' ')[0] as start_point_lng
,split(regexp_replace(open_position,'POINT\\(|\\)',''),' ')[1] as start_point_lat
,split(regexp_replace(close_position,'POINT\\(|\\)',''),' ')[0] as close_point_lng
,split(regexp_replace(close_position,'POINT\\(|\\)',''),' ')[1] as close_point_lat
,date_s
from table_name