AnsweredAssumed Answered

Issue in Sqoop - teradata import

Question asked by Surbhi on Jun 1, 2017
Latest reply on Jul 6, 2017 by satz

Hi,

 

I am trying to sqoop from Tera database to MapR FS.

 

Steps performed: 1. Copied below files in /usr/lib/tdch/1.3/lib/:

      tdgssconfig.jar
      teradata-connector-1.3.4.jar
      terajdbc4.jar

 

2. Run export LIB_JARS=/usr/lib/tdch/1.3/lib/

 

3. Run the below command : sqoop import -libjars $LIB_JARS --connect "jdbc:teradata://<url>/Database=DB" --connection-manager org.apache.connectors.td.TeradataManager --username USERID --password --123 --table CUSTOMER --target-dir /user/mapr/Customer.

 

But errors are coming :17/06/01 03:12:53 INFO tool.CodeGenTool: Beginning code generation
2017-06-01.03:12:53.365 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@2da42f7f Read message 1 failed; closing socket due to: java.net.SocketException: Connection reset
2017-06-01.03:12:53.372 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@2da42f7f Packet receive Thu Jun 01 03:12:53 PDT 2017 socket orig=<url>local=0.0.0.0/0.0.0.0:34641 remote=/<url>1025 keepalive=unavailable nodelay=unavailable receive=unavailable send=unavailable linger=unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=9 connecttotaltime=11 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=7cbc11d sess=0 java.net.SocketException: Connection reset  at java.net.SocketInputSt

.....

.....

 org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)  at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
        at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:95)
        at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:70)
        at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:208)
        at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:59)
        at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:930)
        at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:768)
        at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:103)
        at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:209)
        at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)
        at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)
        at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)
        at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)
        at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:234)

 

 

Could someone suggest where am I making a mistake?

Outcomes