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

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

New Contributor

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

Accepted Solutions

New Contributor

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

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?

New Contributor

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

Contributor

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

 

New Contributor

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

Contributor

Thanks a lot Sebastien....