Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to store ST_GEOMETRY data type in Hive

Solved Go to solution
Highlighted

How to store ST_GEOMETRY data type in Hive

New Contributor

How to store ST_GEOMETRY data type in Hive

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to store ST_GEOMETRY data type in Hive

Hi Gaurav,

That looks like a datatype from Esri Spatial framework . Looking at the docs, you can store a geometry as OGC well-known text (=String) and read it back as a ST_GEOMETRY with the UDF st_geomfromtext: https://github.com/Esri/spatial-framework-for-hadoop/wiki/UDF-Constructors#st_geomfromtext

Regards,

Ward

3 REPLIES 3

Re: How to store ST_GEOMETRY data type in Hive

New Contributor

Kindly let me know the resolution for storing ST_GEOMETRY data type in Hive

Re: How to store ST_GEOMETRY data type in Hive

Hi Gaurav,

That looks like a datatype from Esri Spatial framework . Looking at the docs, you can store a geometry as OGC well-known text (=String) and read it back as a ST_GEOMETRY with the UDF st_geomfromtext: https://github.com/Esri/spatial-framework-for-hadoop/wiki/UDF-Constructors#st_geomfromtext

Regards,

Ward

Re: How to store ST_GEOMETRY data type in Hive

New Contributor

Thanks Ward !! Currently the Spatial data is stored in oracle with data type as ST_GEOMETRY. I have checked in hive, we can't store ST_GEOMETRY datatype. All what we have to do is to change the data type in oracle and store in hive. Now changing the data type in oracle is again a big challenge as ST_AsText(ST_Geometry) or any other function don't work in oracle.

Don't have an account?
Coming from Hortonworks? Activate your account here