teradata jars issue

amol_08 · ‎10-30-2018

I have HDP 2.6.5 installed in the cluster but when i try to run teradata import sqoop job it is failing with below error :

18/10/30 15:16:15 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
18/10/30 15:16:15 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
18/10/30 15:16:15 ERROR sqoop.ConnFactory: Sqoop could not found specified connection manager class o.apache.sqoop.teradata.TeradataConnManager. Please check that you've specified the class correctly.
18/10/30 15:16:15 ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: java.lang.ClassNotFoundException: o.apache.sqoop.teradata.TeradataConnManager
        at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:166)
        at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:266)
        at org.apache.sqoop.tool.CreateHiveTableTool.run(CreateHiveTableTool.java:51)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:225)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:243)
Caused by: java.lang.ClassNotFoundException: o.apache.sqoop.teradata.TeradataConnManager
        at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
        at java.lang.ClassLoader.loadClass(ClassLoader.jar

However teratajars are available under sqoop lib :

tdgssconfig.jar

teradata-connector-1.5.4-hadoop2.jar

terajdbc4.jar

hortonworks-teradata-connector-1.5.4.2.6.5.0-292.jar

jar tvf hortonworks-teradata-connector-1.5.4.2.6.5.0-292.jar | grep org.apache.sqoop.teradata.TeradataConnManager
org/apache/sqoop/teradata/TeradataConnManager.class

quadoss · ‎11-16-2018

@Anurag Mishra

From the exception, it seems like the classname provided is not correct as you can see below, the class name is starting with o and not org which is what is available in the above jar tvf command output.

18/10/30 15:16:15 ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: java.lang.ClassNotFoundException: o.apache.sqoop.teradata.TeradataConnManager