teradata connector for sqoop

peda — Fri, 16 Sep 2022 08:51:30 GMT

Hi,

we installed tradata connector for sqoop. when we try to sqoop the data into hadoop from teradata we are getting following error.

teradata connector is /usr/lib/sqoop-connector-teradata-1.0.0/sqoop-connector-teradata-1.0.0.jar

Teradata JDBC is TeraJDBC__indep_indep.13.10.00.35.tar.

thanks

veera

/opt/cloudera/parcels/CDH-4.4.0-1.cdh4.4.0.p0.39

2013-12-12.17:11:49.332 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@36d1c778 Connection to dwdev Thu Dec 12 17:11:49 UTC 2013 socket orig=dwdev cid=3e364641 sess=0 java.net.UnknownHostException: dwdev at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:849) at java.net.InetAddress.getAddressFromNameService(InetAddress.java:1202) at java.net.InetAddress.getAllByName0(InetAddress.java:1153) at java.net.InetAddress.getAllByName(InetAddress.java:1083) at java.net.InetAddress.getAllByName(InetAddress.java:1019) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:182) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:281) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:130) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:116) at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:580) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:95) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:209) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at com.teradata.hadoop.db.TeradataConnection.connect(TeradataConnection.java:274) at com.cloudera.connector.teradata.TeradataManager.getTeradataConnection(TeradataManager.java:302) at com.cloudera.connector.teradata.TeradataManager.<init>(TeradataManager.java:72) at com.cloudera.connector.teradata.TeradataManagerFactory.accept(TeradataManagerFactory.java:22) at org.apache.sqoop.manager.ManagerFactory.accept(ManagerFactory.java:50) at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:178) at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:225) at org.apache.sqoop.tool.ImportTool.init(ImportTool.java:84) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:490) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
13/12/12 17:11:49 ERROR teradata.TeradataManager: Can't connect to Teradata server
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.35] [Error 1000] [SQLState 08S01] Login failure for Connection to dwdev Thu Dec 12 17:11:49 UTC 2013 socket orig=dwdev cid=3e364641 sess=0 java.net.UnknownHostException: dwdev at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:849) at java.net.InetAddress.getAddressFromNameService(InetAddress.java:1202) at java.net.InetAddress.getAllByName0(InetAddress.java:1153) at java.net.InetAddress.getAllByName(InetAddress.java:1083) at java.net.InetAddress.getAllByName(InetAddress.java:1019) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:182) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:281) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:130) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:116) at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:580) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:95) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:209) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at com.teradata.hadoop.db.TeradataConnection.connect(TeradataConnection.java:274) at com.cloudera.connector.teradata.TeradataManager.getTeradataConnection(TeradataManager.java:302) at com.cloudera.connector.teradata.TeradataManager.<init>(TeradataManager.java:72) at com.cloudera.connector.teradata.TeradataManagerFactory.accept(TeradataManagerFactory.java:22) at org.apache.sqoop.manager.ManagerFactory.accept(ManagerFactory.java:50) at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:178) at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:225) at org.apache.sqoop.tool.ImportTool.init(ImportTool.java:84) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:490) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:206)
at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:61)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:137)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:116)
at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:580)
at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:95)
at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:209)
at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30)
at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130)
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120)
at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220)
at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.teradata.hadoop.db.TeradataConnection.connect(TeradataConnection.java:274)
at com.cloudera.connector.teradata.TeradataManager.getTeradataConnection(TeradataManager.java:302)
at com.cloudera.connector.teradata.TeradataManager.<init>(TeradataManager.java:72)
at com.cloudera.connector.teradata.TeradataManagerFactory.accept(TeradataManagerFactory.java:22)
at org.apache.sqoop.manager.ManagerFactory.accept(ManagerFactory.java:50)
at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:178)
at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:225)
at org.apache.sqoop.tool.ImportTool.init(ImportTool.java:84)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:490)
at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
Caused by: java.net.UnknownHostException: dwdev
at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method)
at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:849)
at java.net.InetAddress.getAddressFromNameService(InetAddress.java:1202)
at java.net.InetAddress.getAllByName0(InetAddress.java:1153)
at java.net.InetAddress.getAllByName(InetAddress.java:1083)
at java.net.InetAddress.getAllByName(InetAddress.java:1019)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:182)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:281)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:130)
... 27 more
13/12/12 17:11:49 ERROR tool.BaseSqoopTool: Got error creating database manager: java.lang.RuntimeException: Can't connect to Teradata server
at com.cloudera.connector.teradata.TeradataManager.getTeradataConnection(TeradataManager.java:305)
at com.cloudera.connector.teradata.TeradataManager.<init>(TeradataManager.java:72)
at com.cloudera.connector.teradata.TeradataManagerFactory.accept(TeradataManagerFactory.java:22)
at org.apache.sqoop.manager.ManagerFactory.accept(ManagerFactory.java:50)
at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:178)
at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:225)
at org.apache.sqoop.tool.ImportTool.init(ImportTool.java:84)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:490)
at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
Caused by: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.35] [Error 1000] [SQLState 08S01] Login failure for Connection to dwdev Thu Dec 12 17:11:49 UTC 2013 socket orig=dwdev cid=3e364641 sess=0 java.net.UnknownHostException: dwdev at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:849) at java.net.InetAddress.getAddressFromNameService(InetAddress.java:1202) at java.net.InetAddress.getAllByName0(InetAddress.java:1153) at java.net.InetAddress.getAllByName(InetAddress.java:1083) at java.net.InetAddress.getAllByName(InetAddress.java:1019) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:182) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:281) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:130) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:116) at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:580) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:95) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:209) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at com.teradata.hadoop.db.TeradataConnection.connect(TeradataConnection.java:274) at com.cloudera.connector.teradata.TeradataManager.getTeradataConnection(TeradataManager.java:302) at com.cloudera.connector.teradata.TeradataManager.<init>(TeradataManager.java:72) at com.cloudera.connector.teradata.TeradataManagerFactory.accept(TeradataManagerFactory.java:22) at org.apache.sqoop.manager.ManagerFactory.accept(ManagerFactory.java:50) at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:178) at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:225) at org.apache.sqoop.tool.ImportTool.init(ImportTool.java:84) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:490) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:206)
at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:61)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:137)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:116)
at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:580)
at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:95)
at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:209)
at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30)
at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130)
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120)
at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220)
at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.teradata.hadoop.db.TeradataConnection.connect(TeradataConnection.java:274)
at com.cloudera.connector.teradata.TeradataManager.getTeradataConnection(TeradataManager.java:302)
... 13 more
Caused by: java.net.UnknownHostException: dwdev
at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method)
at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:849)
at java.net.InetAddress.getAddressFromNameService(InetAddress.java:1202)
at java.net.InetAddress.getAllByName0(InetAddress.java:1153)
at java.net.InetAddress.getAllByName(InetAddress.java:1083)
at java.net.InetAddress.getAllByName(InetAddress.java:1019)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:182)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:281)
at com.teradata.jdbc.

Re: teradata connector for sqoop

peda — Thu, 12 Dec 2013 21:49:15 GMT

The database name is not resolved. I changed it to IP address, it worked.

Re: teradata connector for sqoop

Manikumar Juttukonda — Thu, 12 Dec 2013 22:07:46 GMT

The host name(dwdev) you are using is not recognized by the server where you running the sqoop command.
Try adding 'dwdev' with an ip address in /etc/hosts file and try to run sqoop command again. Hope, it will work....

Re: teradata connector for sqoop

peda — Fri, 20 Dec 2013 22:44:35 GMT

Thanks for the info. it is working.

question teradata connector for sqoop in Archives of Support Questions (Read Only)

teradata connector for sqoop

Re: teradata connector for sqoop

Re: teradata connector for sqoop

Re: teradata connector for sqoop