Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to store ST_GEOMETRY data type in Hive

avatar
Contributor

How to store ST_GEOMETRY data type in Hive

1 ACCEPTED SOLUTION

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
3 REPLIES 3

avatar
Contributor

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

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

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