[SQOOP-2222] sqoop import from teradata to hive

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: no-release
• Assignee: Unassigned
• Reporter: Arti Wadhwani
• Created: 17/Mar/15 11:21
• Updated: 15/Jun/16 19:27
• Resolved: 15/Apr/15 07:20

Description

I am trying to connect to Teradata DB to import its data to hive. So initially tried to test the connection by just listing the tables in Teradata DB using Teradata connector for hadoop (hortonworks and not cloudera)

connector : teradata-connector-1.3.3.jar
hdp 2.2
sqoop version : 1.4.5

sqoop command : sqoop list-tables –connect jdbc:teradata://<TD_DB_hostname>/Database=c_test –connection-manager org.apache.sqoop.teradata.TeradataConnManager –username xxxx –password xxxxx

Error:

15/03/13 18:00:20 ERROR sqoop.ConnFactory: Sqoop could not found specified connection manager class org.apache.sqoop.teradata.TeradataConnManager. Please check that you’ve specified the class correctly.
15/03/13 18:00:20 ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: java.lang.ClassNotFoundException: org.apache.sqoop.teradata.TeradataConnManager

I have extracted the jar and cannot see this class in it. How to fix this?

(PS: I have tested the same for cloudera and it works fine but fails for Hortonworks)

Thanks,
Arti