question Re: How to connect sqoop with Oracle Database (not mysql)? in Archives of Support Questions (Read Only)

How to connect sqoop with Oracle Database (not mysql)?

Sciengtec — Tue, 13 Mar 2018 22:08:13 GMT

I am trying to connect sqoop with oracle database in HDP 2.6.4 Sandbox but once I trying to run any command e.g. sqoop help it gives me following error, screenshot is attached. Kindly help me to fix that so that I can make a connection with Oracle Database. If you have any tutorial for Sqoop to Oracle DB (not mysql) that would be great.

I am also having another issue which is attached in 2nd screen shot and that is also relevant to sqoop. Kindly guide me to fix these thanks.sqoop-openjdk.png

Re: How to connect sqoop with Oracle Database (not mysql)?

Shelton — Wed, 14 Mar 2018 00:02:29 GMT

@Abdul Saboor

Try to inncrease memory on your mappers. Take a look at mapreduce.map.memory.mb, mapreduce.reduce.memory.mb, mapreduce.map.java.opts and mapreduce.reduce.java.opts.

In the below example I have sent it to 1GB, please substitute the values according to your environment

sqoop import -D mapreduce.map.memory.mb=1024 -D mapreduce.map.java.opts=-Xmx768m --connect jdbc:oracle:thin:@oradbhost:15xx:DB --table test --username SYSTEM -P -m 1

Revert

Re: How to connect sqoop with Oracle Database (not mysql)?

Sciengtec — Wed, 14 Mar 2018 01:58:47 GMT

Hi Geoffrey,

Thank you for your answer, I got your point and I do that and update you if there is any problem. Thank for your time. Kindly guide me about the first issue - SLF4J, if you have the solution, kindly guide/suggest me because that is more important and I am facing in couple of VMs.

Cheers,

Re: How to connect sqoop with Oracle Database (not mysql)?

Sciengtec — Wed, 14 Mar 2018 02:29:55 GMT

sqoop-slf4j.png

Re: How to connect sqoop with Oracle Database (not mysql)?

Shelton — Wed, 14 Mar 2018 14:38:40 GMT

@Abdul Saboor

The warning emitted by Simple Logging Facade for Java (SLF4J) is just that, a warning. Even when multiple bindings are present, SLF4J will pick one logging framework/implementation and bind to it.

Re: How to connect sqoop with Oracle Database (not mysql)?

Sciengtec — Wed, 14 Mar 2018 22:13:14 GMT

Thanks Geoffrey, I understand and agree with you. Now I'm trying to execute sqoop command e.g. sqoop list-tables --connect jdbc:oracle:thin:@<IP>:1521/orcl --username system --password oracle, then the same warning appears and could not load driver class. I am taking some guidance from hortonworks community but still unable to fix. Kindly suggest me the appropriate solutions for that. I'll be very grateful to you.

sqoop-error.png