GREAT_CIRCLE_ANGLE
Returns the central angle in degrees between two points on a sphere. The points are specified by longitude and latitude in degrees.
Syntax
GREAT_CIRCLE_ANGLE(<lon1>, <lat1>, <lon2>, <lat2>)
Arguments
Return Type
Float32.
Examples
SELECT GREAT_CIRCLE_ANGLE(55.755831, 37.617673, -55.755831, -37.617673) AS angle;
╭───────────╮
│ angle │
├───────────┤
│ 127.05919 │
╰───────────╯