SSC-FDM-TD0031
ST_DISTANCE results are slightly different from ST_SPHERICALDISTANCE
Description
The Teradata function ST_SPHERICALDISTANCE calculates the distance between two spherical coordinates on the planet using the Haversine formula, on the other side, the Snowflake ST_DISTANCE function does not utilize the haversine formula to calculate the minimum distance between two geographical points.
Example Code
Input Code:
Teradata Output
location1
location2
Distance_In_Km
POINT (-73.989308 40.741895)
POINT (40.741895 34.053691)
9351139.978062356
Output Code
Snowflake Output
LOCATION1
LOCATION2
DISTANCE_IN_KM
{ "coordinates": [ -73.989308, 40.741895 ], "type": "Point" }
{ "coordinates": [ 40.741895, 34.053691 ], "type": "Point" }
9351154.65572674
Recommendations
Last updated