Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

SQOOP IMPORT error from Teradata

Highlighted

SQOOP IMPORT error from Teradata

I am getting the following error when importing a table from Teradata.

Query: ./sqoop-import -libjars $LIB_JARS --connection-manager org.apache.sqoop.teradata.TeradataConnManager --connect jdbc:teradata://<IPADDRESS>/Database=tempdb --table prg_item_x_vendor_rlob --username <Uname>--password <Password> --target-dir /user/sqoop/prg_item_x_vendor_rlob -m --verbose

16/09/07 16:04:39 INFO mapreduce.Job: Task Id : attempt_1473258107951_0011_m_000001_0, Status : FAILED Error: com.teradata.connector.common.exception.ConnectorException: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.00.00.20] [Error 1277] [SQLState 08S01] Login timeout for Connection to 10.95.96.39 Wed Sep 07 16:04:39 EDT 2016 socket orig=10.95.96.39 cid=1cbb3d3b sess=0 java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:1216) at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:94) at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:69) at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:207) at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:59) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:154) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:133) at com.teradata.jdbc.jdbc.GenericTeradataConnection.getIO(GenericTeradataConnection.java:113) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:98) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:205) 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:232) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at com.teradata.connector.teradata.db.TeradataConnection.connect(TeradataConnection.java:388) at com.teradata.connector.teradata.utils.TeradataUtils.openInputConnection(TeradataUtils.java:46) at com.teradata.connector.teradata.TeradataInputFormat$TeradataRecordReader.initialize(TeradataInputFormat.java:88) at com.teradata.connector.common.ConnectorCombineInputFormat$ConnectorCombinePlugedinInputRecordReader.initialize(ConnectorCombineInputFormat.java:505) at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.initialize(MapTask.java:548) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:786) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1709) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162) Caused by: java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:1216) at com.teradata.connector.teradata.utils.TeradataUtils.openInputConnection(TeradataUtils.java:68) at com.teradata.connector.teradata.TeradataInputFormat$TeradataRecordReader.initialize(TeradataInputFormat.java:88) at com.teradata.connector.common.ConnectorCombineInputFormat$ConnectorCombinePlugedinInputRecordReader.initialize(ConnectorCombineInputFormat.java:505) at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.initialize(MapTask.java:548) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:786) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1709) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162) Container killed by the ApplicationMaster. Container killed on request. Exit code is 143 Container exited with a non-zero exit code 143

I am able to list tables and query the table using sqoop-list and sqoop-eval.

Please help

3 REPLIES 3

Re: SQOOP IMPORT error from Teradata

I found something on a Teradata portal: The exception stack trace shows that the Teradata JDBC Driver was unable to connect to the Teradata Database.

If you are able to ping the Teradata Database from the client, but the Teradata JDBC Driver is unable to connect to the Teradata Database via port 1025, then Yes, your firewall may be blocking the connection. If this is a multi-node Teradata Database, the firewall should be configured to permit connections to each Teradata Database node that is running a Gateway process.

is this something related to my issues?

Re: SQOOP IMPORT error from Teradata

Rising Star
@Prashanth Balaiahgari

It looks like security issue. If you are using kerberos , please obtain ticket using kinit command before executing sqoop command in the terminal.

Re: SQOOP IMPORT error from Teradata

Thanks @Arkaprova Saha for looking into the issue. issue is with ports, communication between datanodes and teradata db is not happening.

Don't have an account?
Coming from Hortonworks? Activate your account here