doris版本:1.1.5
doris be 执行查询宕机,be.out be.warning均无记录宕机信息
查看fe日志,发现是先记录无法与be通讯,然后查询才被取消。
be.warning在重启发生时段,没有打印任何信息。
查询messages,不是OOM。
想问下1.1.5版本存在什么已知的会导致该现象的bug吗?
问题sql
SELECT
longitude AS lng,
latitude AS lat,
deviceid,
channel,
daypart
FROM
ads_area.ordering_out_range_errcode
WHERE
error_type = '1'
AND brand = 'PH'
AND dt >= '20250601'
AND dt <= '20250630'
AND data_hour >= 0
AND data_hour <= 23
AND ec_city_code = '00002'
AND (
st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.477773' AS DOUBLE), CAST('39.926574' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.307919' AS DOUBLE), CAST('39.966529' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.299744' AS DOUBLE), CAST('39.824314' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.448617' AS DOUBLE), CAST('39.971258' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.543154' AS DOUBLE), CAST('40.035199' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.273258' AS DOUBLE), CAST('40.067194' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.503691' AS DOUBLE), CAST('39.769481' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.662099' AS DOUBLE), CAST('39.875153' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.35182' AS DOUBLE), CAST('39.759162' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.315082' AS DOUBLE), CAST('40.105295' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.548758' AS DOUBLE), CAST('39.737774' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.314145' AS DOUBLE), CAST('39.630671' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.161384' AS DOUBLE), CAST('39.863671' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.379648' AS DOUBLE), CAST('39.926731' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.547239' AS DOUBLE), CAST('40.066917' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.401476' AS DOUBLE), CAST('39.807632' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.302768' AS DOUBLE), CAST('39.796494' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.550804' AS DOUBLE), CAST('39.90975' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.419291' AS DOUBLE), CAST('39.952505' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.231795' AS DOUBLE), CAST('39.880367' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.414629' AS DOUBLE), CAST('39.840578' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.079861' AS DOUBLE), CAST('39.716271' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.573884' AS DOUBLE), CAST('39.802637' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.367146' AS DOUBLE), CAST('40.09962' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.293977' AS DOUBLE), CAST('39.933271' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.655346' AS DOUBLE), CAST('40.159862' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.313593' AS DOUBLE), CAST('40.068522' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.586074' AS DOUBLE), CAST('39.772029' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.30512' AS DOUBLE), CAST('39.512989' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.564464' AS DOUBLE), CAST('39.862976' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.132641' AS DOUBLE), CAST('40.234984' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.125812' AS DOUBLE), CAST('39.723597' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.52778' AS DOUBLE), CAST('39.859004' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.680233' AS DOUBLE), CAST('39.865983' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.602222' AS DOUBLE), CAST('39.889822' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.303231' AS DOUBLE), CAST('39.814188' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.408904' AS DOUBLE), CAST('39.951506' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.533466' AS DOUBLE), CAST('39.905444' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.375506' AS DOUBLE), CAST('39.961946' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.358368' AS DOUBLE), CAST('39.851116' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.588322' AS DOUBLE), CAST('39.818023' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('115.963453' AS DOUBLE), CAST('39.722168' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.464258' AS DOUBLE), CAST('39.568471' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.612806' AS DOUBLE), CAST('40.116735' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.505718' AS DOUBLE), CAST('39.889908' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.656157' AS DOUBLE), CAST('40.203114' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.641426' AS DOUBLE), CAST('39.927495' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.530021' AS DOUBLE), CAST('39.873546' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.334524' AS DOUBLE), CAST('39.928426' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.255193' AS DOUBLE), CAST('39.929913' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.334336' AS DOUBLE), CAST('39.996246' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.164638' AS DOUBLE), CAST('40.068113' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.632071' AS DOUBLE), CAST('40.108006' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.403788' AS DOUBLE), CAST('39.707962' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.84164' AS DOUBLE), CAST('39.798583' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.553985' AS DOUBLE), CAST('40.155108' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.331606' AS DOUBLE), CAST('39.738185' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.794583' AS DOUBLE), CAST('39.780525' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('115.901012' AS DOUBLE), CAST('40.373564' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.261409' AS DOUBLE), CAST('40.169724' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.45968' AS DOUBLE), CAST('39.955643' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.448609' AS DOUBLE), CAST('39.958854' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.343001' AS DOUBLE), CAST('39.937761' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.685202' AS DOUBLE), CAST('40.082251' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.461302' AS DOUBLE), CAST('39.97872' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.435359' AS DOUBLE), CAST('40.073455' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('117.009899' AS DOUBLE), CAST('40.063873' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.527176' AS DOUBLE), CAST('40.011623' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.445221' AS DOUBLE), CAST('39.941611' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.417619' AS DOUBLE), CAST('39.898187' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.326188' AS DOUBLE), CAST('39.967731' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.463787' AS DOUBLE), CAST('40.001038' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.501693' AS DOUBLE), CAST('39.915052' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.336521' AS DOUBLE), CAST('39.993384' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.307692' AS DOUBLE), CAST('39.908763' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.460628' AS DOUBLE), CAST('39.882368' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.355025' AS DOUBLE), CAST('39.924223' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.337695' AS DOUBLE), CAST('39.889576' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.330304' AS DOUBLE), CAST('39.939178' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.490365' AS DOUBLE), CAST('39.976147' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.339297' AS DOUBLE), CAST('39.730255' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.37515' AS DOUBLE), CAST('39.895515' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.319192' AS DOUBLE), CAST('40.075705' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.310539' AS DOUBLE), CAST('39.926195' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.356941' AS DOUBLE), CAST('39.891257' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.355982' AS DOUBLE), CAST('39.953997' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.371232' AS DOUBLE), CAST('39.947314' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.311584' AS DOUBLE), CAST('40.02825' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.414773' AS DOUBLE), CAST('40.060343' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.224362' AS DOUBLE), CAST('39.906543' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.500876' AS DOUBLE), CAST('39.86712' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.294844' AS DOUBLE), CAST('39.972956' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.329819' AS DOUBLE), CAST('40.056677' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.518253' AS DOUBLE), CAST('39.92394' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.447025' AS DOUBLE), CAST('39.857991' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.289845' AS DOUBLE), CAST('39.998489' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.429234' AS DOUBLE), CAST('39.846443' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.34641' AS DOUBLE), CAST('39.976125' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.273358' AS DOUBLE), CAST('39.906914' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.265198' AS DOUBLE), CAST('39.887899' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.200734' AS DOUBLE), CAST('39.932112' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.414977' AS DOUBLE), CAST('40.07059' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.385804' AS DOUBLE), CAST('39.843944' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.335288' AS DOUBLE), CAST('40.030107' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.271057' AS DOUBLE), CAST('40.016146' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.345804' AS DOUBLE), CAST('39.907968' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.444194' AS DOUBLE), CAST('39.934328' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('115.98422' AS DOUBLE), CAST('39.702238' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.595696' AS DOUBLE), CAST('39.926085' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.285421' AS DOUBLE), CAST('39.958595' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.501775' AS DOUBLE), CAST('39.806552' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.659272' AS DOUBLE), CAST('39.889318' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.639753' AS DOUBLE), CAST('39.905538' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.340332' AS DOUBLE), CAST('39.791348' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.32759' AS DOUBLE), CAST('39.789851' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.16057' AS DOUBLE), CAST('39.756879' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.547868' AS DOUBLE), CAST('39.951303' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('117.094371' AS DOUBLE), CAST('40.146061' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.373343' AS DOUBLE), CAST('39.909831' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.170031' AS DOUBLE), CAST('40.235046' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.403125' AS DOUBLE), CAST('39.933372' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.252434' AS DOUBLE), CAST('39.902949' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.364636' AS DOUBLE), CAST('39.871819' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.459669' AS DOUBLE), CAST('39.805813' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.321227' AS DOUBLE), CAST('39.686123' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.332237' AS DOUBLE), CAST('39.764263' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.449293' AS DOUBLE), CAST('39.922362' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.366922' AS DOUBLE), CAST('39.814336' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.324682' AS DOUBLE), CAST('39.826771' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.545194' AS DOUBLE), CAST('39.753151' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.417433' AS DOUBLE), CAST('40.031196' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.83451' AS DOUBLE), CAST('40.35536' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.393888' AS DOUBLE), CAST('40.00137' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.557858' AS DOUBLE), CAST('40.118234' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.406247' AS DOUBLE), CAST('39.977919' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.652363' AS DOUBLE), CAST('40.178907' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.630213' AS DOUBLE), CAST('40.316054' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.634923' AS DOUBLE), CAST('40.129636' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.504994' AS DOUBLE), CAST('40.034347' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.678488' AS DOUBLE), CAST('39.895652' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.139494' AS DOUBLE), CAST('39.735478' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.141521' AS DOUBLE), CAST('39.744982' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.685163' AS DOUBLE), CAST('39.934974' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.318599' AS DOUBLE), CAST('39.671466' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.596403' AS DOUBLE), CAST('40.01133' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.123156' AS DOUBLE), CAST('39.906154' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.487923' AS DOUBLE), CAST('39.889022' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.1904' AS DOUBLE), CAST('40.040587' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.533585' AS DOUBLE), CAST('39.8027' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.238356' AS DOUBLE), CAST('40.212152' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('115.983899' AS DOUBLE), CAST('40.473681' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.335214' AS DOUBLE), CAST('39.866745' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.743805' AS DOUBLE), CAST('39.888532' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.247193' AS DOUBLE), CAST('40.075558' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.342895' AS DOUBLE), CAST('39.964758' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.18492' AS DOUBLE), CAST('39.733524' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.65916' AS DOUBLE), CAST('39.908617' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.354424' AS DOUBLE), CAST('40.008662' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.398803' AS DOUBLE), CAST('40.002992' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.437249' AS DOUBLE), CAST('40.028726' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.287731' AS DOUBLE), CAST('40.150507' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.157388' AS DOUBLE), CAST('39.914972' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.172694' AS DOUBLE), CAST('39.923051' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.069492' AS DOUBLE), CAST('39.649565' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.111524' AS DOUBLE), CAST('39.890064' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.675146' AS DOUBLE), CAST('40.112362' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.173117' AS DOUBLE), CAST('39.819157' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.233251' AS DOUBLE), CAST('40.218627' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.495196' AS DOUBLE), CAST('39.962196' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.378159' AS DOUBLE), CAST('39.836204' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.658421' AS DOUBLE), CAST('39.923563' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.49473' AS DOUBLE), CAST('39.75357' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.406489' AS DOUBLE), CAST('40.034017' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.414141' AS DOUBLE), CAST('40.116953' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.722519' AS DOUBLE), CAST('39.948931' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.432324' AS DOUBLE), CAST('39.865828' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.448979' AS DOUBLE), CAST('39.75902' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.469001' AS DOUBLE), CAST('39.992261' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.651416' AS DOUBLE), CAST('40.12882' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.304209' AS DOUBLE), CAST('39.868213' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.355175' AS DOUBLE), CAST('40.037964' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.540419' AS DOUBLE), CAST('40.08819' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.433833' AS DOUBLE), CAST('39.883528' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.099171' AS DOUBLE), CAST('39.943794' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.3721' AS DOUBLE), CAST('40.084183' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.387846' AS DOUBLE), CAST('39.881288' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.406511' AS DOUBLE), CAST('39.991501' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.292759' AS DOUBLE), CAST('40.097764' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.551403' AS DOUBLE), CAST('39.849852' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.365957' AS DOUBLE), CAST('40.061398' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.29779' AS DOUBLE), CAST('39.882706' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.438564' AS DOUBLE), CAST('40.042973' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.54881' AS DOUBLE), CAST('39.962263' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE), CAST('116.335363' AS DOUBLE), CAST('40.079343' AS DOUBLE)) <= 5000
OR st_distance_sphere(CAST(longitude AS DOUBLE), CAST(latitude AS DOUBLE