[ 
https://issues.apache.org/jira/browse/HIVE-29353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ramit Gupta reassigned HIVE-29353:
----------------------------------

    Assignee: Ramit Gupta

> Add ST_GeoHash
> --------------
>
>                 Key: HIVE-29353
>                 URL: https://issues.apache.org/jira/browse/HIVE-29353
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Csaba Ringhofer
>            Assignee: Ramit Gupta
>            Priority: Major
>
> geohash calculation for points at given precision is very simple. For complex 
> geometries there are several options:
> a. find a geohash where the whole shape fits, potentially decreasing precision
> b. calculate geohash for a given point (e.g. center of envelope) of the shape
> c. simply reject non-point geometries
> postgis does a. ([link|https://postgis.net/docs/ST_GeoHash.html]) while 
> Apache Sedona does b. 
> ([link|https://github.com/apache/sedona/blob/0523fbdc600d86b8088feba39db829a5dccc11d8/common/src/main/java/org/apache/sedona/common/utils/GeometryGeoHashEncoder.java#L40])



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to