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

[#1]

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

[#2 · Accepted solution]

@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.