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:
IN -> Teradata_01.sql
Teradata Output
location1 | location2 | Distance_In_Km |
---|---|---|
POINT (-73.989308 40.741895) | POINT (40.741895 34.053691) | 9351139.978062356 |
Output Code
OUT -> Teradata_01.sql
Snowflake Output
LOCATION1 | LOCATION2 | DISTANCE_IN_KM |
---|---|---|
{ "coordinates": [ -73.989308, 40.741895 ], "type": "Point" } | { "coordinates": [ 40.741895, 34.053691 ], "type": "Point" } | 9351154.65572674 |
Recommendations
If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated