question Re: I can't get sqoop to work with teradata after following the documentation. in Archives of Support Questions (Read Only)

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

Sebastien — Fri, 16 Sep 2022 09:02:15 GMT

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.

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

abe — Wed, 16 Jul 2014 19:09:03 GMT

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?

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

Sebastien — Thu, 17 Jul 2014 20:39:57 GMT

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!

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

AmitD — Fri, 22 Aug 2014 18:38:07 GMT

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

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

Sebastien — Mon, 25 Aug 2014 14:50:52 GMT

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

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

AmitD — Mon, 25 Aug 2014 15:19:47 GMT

Thanks a lot Sebastien....