Created 09-07-2016 08:12 PM
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
Created 09-07-2016 08:32 PM
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?
Created 09-21-2016 07:18 AM
It looks like security issue. If you are using kerberos , please obtain ticket using kinit command before executing sqoop command in the terminal.
Created 09-21-2016 01:45 PM
Thanks @Arkaprova Saha for looking into the issue. issue is with ports, communication between datanodes and teradata db is not happening.