Archives of Support Questions (Read Only)

mahipal_ramidi · ‎08-07-2016

Are there other spatial frameworks that can work with ESRI Spatial Framework and Hive and provide the missing functions in ESRI framework for Hadoop?

cstanca · ‎08-08-2016

@Mahipal Ramidi

I assume you mean functions missing or having a different behavior documented here: https://github.com/Esri/spatial-framework-for-hadoop/wiki/ST_Geometry-in-Hive-versus-SQL. Their number is not that high. I think that is more pragmatic to either contribute to ESRI open source project (https://github.com/Esri/spatial-framework-for-hadoop) and maybe others will contribute too as such that everybody wins. Other option, is to write yourself the a few functions missing, or convince ESRI to add the missing functions. Adding another framework into the mix can complicate your implementation. You could have a small SQL Server database where these functions are available, pre-process the data before bring it to Hive and denormalize your tables to add those columns needed for missing functions.

View solution in original post

cstanca · ‎08-08-2016

@Mahipal Ramidi

I assume you mean functions missing or having a different behavior documented here: https://github.com/Esri/spatial-framework-for-hadoop/wiki/ST_Geometry-in-Hive-versus-SQL. Their number is not that high. I think that is more pragmatic to either contribute to ESRI open source project (https://github.com/Esri/spatial-framework-for-hadoop) and maybe others will contribute too as such that everybody wins. Other option, is to write yourself the a few functions missing, or convince ESRI to add the missing functions. Adding another framework into the mix can complicate your implementation. You could have a small SQL Server database where these functions are available, pre-process the data before bring it to Hive and denormalize your tables to add those columns needed for missing functions.