Error with hadoop connector

#1

I am trying to get started with the hadoop connector for couchbase. I installed Cloudera Manager 5.5.1 and that installed all the HDFS, SQOOP, Hive and others.

I then installed connector version 1.2 and tried to import but getting the following error

sqoop import --connect http://servername:8091/pools --table DUMP --username bucket_name -P

Warning: /opt/cloudera/parcels/CDH-5.5.1-1.cdh5.5.1.p0.11/bin/…/lib/sqoop/…/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
16/01/25 01:12:04 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.5.1
Enter password:

16/01/25 01:12:10 ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: No manager for connect string: http://servername:8091/pools
at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:191)
at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:258)
at org.apache.sqoop.tool.ImportTool.init(ImportTool.java:89)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:593)
at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)

I am able to connect to http://servername:8091/pools and see the output. What could be the issue?

#2

Any pointers would be very helpful.

#3

Is that the literal output, or did you change the server name to “servername” in the connection string you passed in in on the command line not in the second?

#4

I did change the server name to not show my full URL. I have edited my original posting. Can you edit yours too? And thanks for looking into this.

#5

Edited to remove the server name. I am offsite for the next couple of days unfortunately but I can try this out later this week.

I don’t think the Accumulo warning has anything to do with the problem.

I suppose you’ve checked all the basic stuff - that the bucket “bucket_name” exists, that it has documents in it, that you have permissions to access it, that the connector jars installed in the right place and so forth? I did see that you can call pools but it might make sense to recheck that you can get the data out through another means.

#6

Bucket name exists and has documents and the user name is the same as the bucket name and hence I assume it has permissions. The jar files are installed in both /var/lib/sqoop and /var/lib/sqoop2 in CentOS installation as I was not sure which version of sqoop was being used.

Siva

#7

Sqoop 1, should be. Not sure what’s going on here, will have to check it when I get some time.

#8

That seems to indicate something has gone wrong with the installation. It’s been a while since I looked at this but what the Couchbase connector does at the moment is grabs the “http://” configuration space for itself in sqoop. Since sqoop is saying there is “No manager for connect string”, the install may not have gone correctly.

I’d recommend walking through the manual install instructions (let me know if you need a pointer) to verify. Various releases of CDH have changed the layout and there are different install methods.