1

We are in the process of migrating from traditional RDMS technologies to HIVE and in the process we have few questions on HIVE spatial capabilties. 1) Mapping of operation dbo.fHTMToString spatial from sql server operation to HIVE 2) Mapping of operation dbo.FHtmToLatLon spatial from sql server operation in HIVE

ashish
  • 13
  • 5

2 Answers2

0

Spatial functions are not available yet in Hive. There are a proposal document you can find here: https://cwiki.apache.org/confluence/display/Hive/Spatial+queries

leftjoin
  • 36,950
  • 8
  • 57
  • 116
0

Try the Esri Spatial Framework for Hadoop, which includes an implementation of ST_Geometry for Hive.

You can start with the sample for Hive in the GIS Tools for Hadoop repository.

There are example calls to the various ST_Geometry UDFs in the scripts under spatial-framework-for-hadoop/hive/test/.

(Disclosure: I'm a collaborator.)

Randall Whitman
  • 411
  • 2
  • 13