Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Explorer

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.

1 ACCEPTED SOLUTION

avatar
Explorer

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!

View solution in original post

5 REPLIES 5

avatar
Expert Contributor
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?

avatar
Explorer

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!

avatar
Rising Star

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

 

avatar
Explorer

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

avatar
Rising Star

Thanks a lot Sebastien....