[
https://issues.apache.org/jira/browse/HIVE-26222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sylwester Lachiewicz updated HIVE-26222:
----------------------------------------
Description: This is an epic Jira to support GeoSpatial datatypes natively
in Hive. This will cater to the applications which queries on large volumes of
spatial data. This support will be added in a phased manner. To start with, we
are planning to make use of framework developed by ESRI
[https://github.com/Esri/spatial-framework-for-hadoop
|https://github.com/Esri/spatial-framework-for-hadoop).] This project is not
very active and there is no release done to maven central. So its not easy to
get the jars downloaded directly using pom dependency. Also the UDFs are based
on older version of Hive. So we have decided to make a copy of this repo and
maintained it inside Hive. This will make it easier to do any improvement and
manage dependencies. As of now, the data loading is done only on a binary data
type. We need to enhance this to make it more user friendly. In the next
phase, a native Geometry/Geography datatype will be supported. User can
directly create a geometry type and operate on it. Apart from these we can
start adding support for different indices like quad tree, R-tree,
ORC/Parquet/Iceberg support etc. (was: This is an epic Jira to support
GeoSpatial datatypes natively in Hive. This will cater to the applications
which queries on large volumes of spatial data. This support will be added in a
phased manner. To start with, we are planning to make use of framework
developed by ESRI ([https://github.com/Esri/spatial-framework-for-hadoop).]
This project is not very active and there is no release done to maven central.
So its not easy to get the jars downloaded directly using pom dependency. Also
the UDFs are based on older version of Hive. So we have decided to make a copy
of this repo and maintained it inside Hive. This will make it easier to do any
improvement and manage dependencies. As of now, the data loading is done only
on a binary data type. We need to enhance this to make it more user friendly.
In the next phase, a native Geometry/Geography datatype will be supported. User
can directly create a geometry type and operate on it. Apart from these we can
start adding support for different indices like quad tree, R-tree,
ORC/Parquet/Iceberg support etc. )
> Native GeoSpatial Support in Hive
> ---------------------------------
>
> Key: HIVE-26222
> URL: https://issues.apache.org/jira/browse/HIVE-26222
> Project: Hive
> Issue Type: Task
> Components: Hive, HiveServer2
> Reporter: mahesh kumar behera
> Assignee: mahesh kumar behera
> Priority: Major
>
> This is an epic Jira to support GeoSpatial datatypes natively in Hive. This
> will cater to the applications which queries on large volumes of spatial
> data. This support will be added in a phased manner. To start with, we are
> planning to make use of framework developed by ESRI
> [https://github.com/Esri/spatial-framework-for-hadoop
> |https://github.com/Esri/spatial-framework-for-hadoop).] This project is not
> very active and there is no release done to maven central. So its not easy to
> get the jars downloaded directly using pom dependency. Also the UDFs are
> based on older version of Hive. So we have decided to make a copy of this
> repo and maintained it inside Hive. This will make it easier to do any
> improvement and manage dependencies. As of now, the data loading is done only
> on a binary data type. We need to enhance this to make it more user
> friendly. In the next phase, a native Geometry/Geography datatype will be
> supported. User can directly create a geometry type and operate on it. Apart
> from these we can start adding support for different indices like quad tree,
> R-tree, ORC/Parquet/Iceberg support etc.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
