Support Questions
Find answers, ask questions, and share your expertise

teradata connector for sqoop

Explorer

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Expert Contributor
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....
Em Jay

View solution in original post

3 REPLIES 3

Explorer

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

Expert Contributor
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....
Em Jay

View solution in original post

Explorer
Thanks for the info. it is working.