根据给定城市下的经纬度计算xx公里内的目标

set lat1=48.14587642091296; -- 纬度
set lon1=11.561324326832132; -- 经度
set ctryname='德国';
set cityname='慕尼黑';
create table tmp_bu_.tmp_mnh as 
select 
distinct  
ASIN(
       SQRT(
             POWER(SIN((${hivevar:lat1}-glat)*ACOS(-1)/360),2) +
             COS(${hivevar:lat1}*ACOS(-1)/180)*COS(glat*ACOS(-1)/180)
             *POWER(SIN((${hivevar:lon1}-glon)*ACOS(-1)/360),2)
       )
 )*6378137*2/1000 as distance
,'${hivevar:lat1}' as lat1
,'${hivevar:lon1}' as lon1
,${ctryname} as countryname
,${cityname} as cityname
,masterhotelid
,hotelname
,hotel_engname
,address
,star
,glat
,glon
from xxx_db.xxx_hotel_xxx
where 1=1
and countryname=${ctryname}
and cityname=${cityname}
having distance<=10
;