[
https://issues.apache.org/jira/browse/HIVE-29352?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HIVE-29352:
----------------------------------
Labels: pull-request-available (was: )
> Add ST_DistanceSphere for points
> --------------------------------
>
> Key: HIVE-29352
> URL: https://issues.apache.org/jira/browse/HIVE-29352
> Project: Hive
> Issue Type: Sub-task
> Reporter: Csaba Ringhofer
> Priority: Major
> Labels: pull-request-available
>
> ST_DistanceSphere uses a simple formula to calculate distance between points.
> Getting the shortest distance between complex shapes like polygons is much
> more complicated so I would postpone that till a library is found for it.
> Apache Trino / Sedona also implement it properly only for points (e.g
> [link|https://github.com/trinodb/trino/blob/e38f360675762e6b64b89e89319d81ffc07fe474/plugin/trino-geospatial/src/main/java/io/trino/plugin/geospatial/GeoFunctions.java#L1638]).
> A workaround is to calculate the centroid of complex shapes (st_centroid)
> and use ST_DistanceSphere on the returned points.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
