About 23_gaurav_jain

23_gaurav_jain · ‎04-21-2017

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.

23_gaurav_jain · ‎04-12-2017

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

23_gaurav_jain · ‎04-10-2017

How to store ST_GEOMETRY data type in Hive

23_gaurav_jain · ‎02-03-2017

Thanks Rajendra, as of now we have installed sqoop client in 28 nodes, so can we uninstall the sqoop client and keep the client in 2 or 3 nodes ??

23_gaurav_jain · ‎02-03-2017

We have a cluster of 28 nodes and working in a firewall Environment and scoop client is installed in all 28 nodes. We need to scoop data from oracle(outside organisation) to hive. For Sqooping do we need to open all the ports 28 nodes IP to external oracle IP. or is there any alternative way by which we can give a single IP and establish the connection.

Online	Offline
Last Visited	‎01-03-2018 08:21 AM

Member Since	‎01-09-2017 06:41 AM
Last Visited	‎01-03-2018 08:21 AM
Posts	17
Kudos received	1

Cloudera Community

Cloudera Community

Re: How to store ST_GEOMETRY data type in Hive

Re: How to store ST_GEOMETRY data type in Hive

How to store ST_GEOMETRY data type in Hive

Re: how sqoop talks to external world.

how sqoop talks to external world.