Reply
New Contributor
Posts: 4
Registered: ‎07-15-2014
Accepted Solution

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

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.

Cloudera Employee abe
Cloudera Employee
Posts: 109
Registered: ‎08-08-2013

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

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
Posts: 4
Registered: ‎07-15-2014

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

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!

Contributor
Posts: 26
Registered: ‎06-19-2014

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

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
Posts: 4
Registered: ‎07-15-2014

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

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

Highlighted
Contributor
Posts: 26
Registered: ‎06-19-2014

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

Thanks a lot Sebastien....

Announcements
New solutions