Sqoop import from oracle to hdfs: No more data to read from socket

0
votes

I'm trying to import data from Oracle to HDFS using Sqoop. Oracle version: 10.2.0.2 Table is not having constraints. When I mention number of mappers(-m) and --split-by parameters, it's showing the error: No more data to read from socket. If I mention -m 1(setting the number of mappers as 1), it's running, but taking too much time. Sqoop command: sqoop import --connect jdbc:oracle:thin:@host:port:SID --username uname --password pwd --table abc.market_price --target-dir /ert/etldev/etl/market_price -m 4 --split-by MNTH_YR

Please help me.

1
sqloraclehadoopsqoopojdbc

1 Answers

0
votes

Instead of giving the num of mappers why dont you try using --direct ..

what does it show then??

sqoop import --connect jdbc:oracle:thin:@host:port:SID --username uname --password pwd --table abc.market_price --target-dir /ert/etldev/etl/market_price --direct

or

sqoop import --connect jdbc:oracle:thin:@host:port:SID --username uname --password pwd --table abc.market_price --target-dir /ert/etldev/etl/market_price --split-by MNTH_YR --direct