haversine distance in Athena

Question

I'm looking for a way to calculate haversine distance between two geographical points (lat and lon) in Athena! In presto, we have something like great_circle_distance but Athena doesn't have it. Any suggestion?

Answer 1

This is now available in Athena engine version 2: https://docs.aws.amazon.com/athena/latest/ug/geospatial-functions-list-v2.html