data import from different oracle table to HDFS using sqoop

RajendraLadkat

Hi All,

I have to transfer data from oracle table to HDFS using sqoop but I am getting connection timeout error. Can some one guide me on this.

Thanks,

Rajendra

JeromeFr

Hi @RajendraLadkat,

Which version of Oracle, which version of sqoop, which version of HDFS, what distribution of Hadoop (if any), what is the hardware, what is your code, what is the exact error message and what have you already tried/investigated?

Have you checked it's not just a network issue?

Regards,

JeromeFr

RajendraLadkat

Hi JeromrFr,

I am using oracle 11g express addition with cloudera  CDH5. I am using sqoop import command. error message is "connection time out".

I have tried connection between CDH5 and oracle database which is located on different windows machine.

Thanks,

Rajendra

Srinath Menon-Oracle

Hi Rajendra ,

Can you post the exact command along with the parameters that you are using ?

Connection time out b/w oracle table and sqoop?

Thanks,

Srinath

RajendraLadkat

Hi Srinath,

Please find the below command which I am using.

sqoop import connect jdbc:oracle:thin:@ipaddress:1521:dbm1

–username system password <> - system.Employee -Target Directory name

Thanks,

Rajendra

dvohra21

What is - system.Employee?

If table name should be preceded by --table

An example sqoop import command is as follows:

sqoop import --connect "jdbc:oracle:thin:@ipaddress:1521:dbm1"  --password "password" --username "username" --table "system.Employee" --columns "col1,col2,col3" --split-by "col1" --target-dir "/import" –verbose

dvohra21

Refer

http://www.toadworld.com/platforms/oracle/w/wiki/11405.using-oracle-database-with-cdh-5-2-sqoop-1-4-5