I can't get sqoop to work with teradata after following the documentation.

[#1]

14/07/15 13:26:46 ERROR tool.BaseSqoopTool: Got error creating database manager: java.lang.NullPointerException

at java.util.Arrays.sort(Arrays.java:1078)

at org.apache.sqoop.ConnFactory.loadManagersFromConfDir(ConnFactory.java:289)

at org.apache.sqoop.ConnFactory.instantiateFactories(ConnFactory.java:85)

at org.apache.sqoop.ConnFactory.<init>(ConnFactory.java:62)

at com.cloudera.sqoop.ConnFactory.<init>(ConnFactory.java:36)

at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:225)

at org.apache.sqoop.tool.ExportTool.run(ExportTool.java:89)

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)

Thank you for any help.

[#2]

Hey there, are you using The Cloudera Connector Powered by Teradata or the Cloudera Connector for Teradata?

Also, what does your sqoop-site.xml have in it?

[#3 · Accepted solution]

chmod 755 /etc/sqoop/conf/managers.d

chmod 644 /etc/sqoop/conf/managers.d/cldra_td_connector.txt

The commands above have solved the issue. This should be added to the guide.

Thanks!

[#4]

Hi Sebastian,

can you please help me in two points 

1) where do put the connector jar file?

I placed it in /var/lib/scoop

2) t what should be the content of this file /etc/sqoop/conf/managers.d/cldra_td_connector.tx?

i did 

manager.class.name=/var/lib/sqoop/sqoop-connector-teradata-1.2c5.jar

I have been struggeling to get this thig work ... so far no luck 

Documentation is really bad ...

Thanks,

Amit

[#5]

Hi Amit,

This is what is in my cldra_td_connector.txt

• com.cloudera.connector.teradata.TeradataManagerFactory=/opt/cloudera/parcels/CDH-4.4.0-1.cdh4.4.0.p0.39/lib/sqoop/lib/sqoop-connector-teradata-1.2c5.jar
• com.cloudera.connector.teradata.TeradataManagerFactory=/var/lib/scoop/sqoop-connector-teradata-1.2c5.jar

However you need to change the path to the full path of the location of your connector jar file. I assume yours will be the 2nd option above.

What error are you getting? Make sure your folders/files have read access for the user executing sqoop.

Sebastien

[#6]

Thanks a lot Sebastien....