HAVERSINE
Calculates the great circle distance in kilometers between two points on the Earth’s surface, using the Haversine formula. The two points are specified by their latitude and longitude in degrees.
Syntax
HAVERSINE(<lat1>, <lon1>, <lat2>, <lon2>)
Arguments
Return Type
Double.
Examples
SELECT
HAVERSINE(40.7127, -74.0059, 34.0500, -118.2500) AS distance
┌────────────────┐
│ distance │
├────────────────┤
│ 3936.390533556 │
└────────────────┘