[jira] [Created] (IMPALA-11745) Add Hive's ESRI geospatial functions as builtins

["Csaba Ringhofer (Jira)" <ji...@apache.org>]

Csaba Ringhofer created IMPALA-11745:
----------------------------------------

             Summary: Add Hive's ESRI geospatial functions as builtins
                 Key: IMPALA-11745
                 URL: https://issues.apache.org/jira/browse/IMPALA-11745
             Project: IMPALA
          Issue Type: New Feature
          Components: Frontend
            Reporter: Csaba Ringhofer


Hive has added the Esri Hive UDFs as builtin functions in HIVE-26223.
The original Hive Esri source: https://github.com/Esri/spatial-framework-for-hadoop

A simple (but inefficient) way to add postgis style geospatial support in Impala is to import these functions through Hive and add them as builtins. This is possible as Impala supports Hive UDFs, but is much slower than a native implementation could be.

My plan is to add these functions depending on a flag, e.g. uf geospatial_library=hive_esri. This would allow native implementations to be added later and let users choose between Hive compatibility and speed. It could also make sense override only the more critical functions with native ones, but it may turn out that the binary format used in ESRI is suboptimal for a native implementation.



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