question Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail in Archives of Support Questions (Read Only)

Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

nitin1309 — Tue, 21 Apr 2026 13:59:55 GMT

I have been trying to import SQL Server Data using a Hue Data Connector..

On the web page: http://www.cloudera.com/content/cloudera/en/documentation/cdh4/latest/CDH4-Installation-Guide/cdh4ig_topic_13_7.html they asked me to install the JDBC 4 driver for SQL Server and after running the following commands on the terminal, I could install the JDBC 4 SQL Server Driver.

Now when I am trying to execute the following command

sqoop import --connect jdbc:sql://myserver --username Me --table Mytable

I get the following error.

Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
14/12/04 10:15:58 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.2.0
14/12/04 10:15:59 WARN sqoop.ConnFactory: Parameter --driver is set to an explicit driver however appropriate connection manager is not being set (via --connection-manager). Sqoop is going to fall back to org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which connection manager should be used next time.
14/12/04 10:15:59 INFO manager.SqlManager: Using default fetchSize of 1000
14/12/04 10:15:59 INFO tool.CodeGenTool: Beginning code generation
14/12/04 10:16:00 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: com.microsoft.jdbc.sqlserver.SQLServerDrive
java.lang.RuntimeException: Could not load db driver class: com.microsoft.jdbc.sqlserver.SQLServerDrive
   at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:848)
   at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
   at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:736)
   at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:759)
   at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:269)
   at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240)
   at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:226)
   at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295)
   at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1829)
   at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1641)
   at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
   at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478)
   at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
   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)

Is it smething to do with the way I have set up the VM ?

How do I set the $ACCUMULO_HOME to the root of your Accumulo installation ?

Thank You in Advance!

Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

HDFS — Fri, 05 Dec 2014 19:53:56 GMT

Accumulo is just a warning

You need to put the sql connector jar in /var/lib/sqoop to make it work.

Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

abe — Fri, 05 Dec 2014 21:46:55 GMT

Check your connection URL as well.
sqoop import --connect jdbc:sqlserver://server;database=db --table table

Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

nitin1309 — Fri, 12 Dec 2014 15:25:08 GMT

Thank You Abe.. I have placed the SQLJDBC4.jar driver in the /var/lib/sqoop/ as well as /var/lib/sqoop2/ folder.

Am using the query to import top 10 rows from a dumy table and it works great.

sqoop import --connect "jdbc:sqlserver://myserver;database=MyDB" --username me --password pwd --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --query 'select top 10 ACODE from [dbo].[ACNT] WHERE $CONDITIONS' -m 1 --target-dir /tmp/test_sqoop/

I still get the WARNING

Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.

I know its only a warning, I just wanna make sure I dont have to install APACHE ACCUMULO to fix this ?

Thanks!

Nithin

Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

abe — Fri, 12 Dec 2014 15:28:49 GMT

Yeah it's only a warning. To make the warning go away you need to install ACCUMULO.

Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

jlibster — Wed, 09 Nov 2016 19:57:46 GMT

I installed Accumulo using Cloudera 5.8.3 parcel manager, and activated (did not happen on the initial wizard but when button said "activate" on the parcel summary it did activate afte rthat) but I'm still getting this message. So, what is going on here...

Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

Romainr — Wed, 09 Nov 2016 20:48:42 GMT

This is a warning that can safely be ignored (several people reported it).

Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

skt1432 — Mon, 13 Mar 2017 19:17:36 GMT

Can you please help me how to install Accumulo. I have

QuickStarts for CDH 5.8 in VMWare.

Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

skt1432 — Tue, 14 Mar 2017 16:54:28 GMT

Though it is a warning. My data is not imported.

While running any sqoop query, it prompts accumulo not set.

Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

Tanuj83 — Wed, 22 Mar 2017 13:52:37 GMT

You can use the following commands:

1. sudo mkdir /var/lib/accumulo

2. ACCUMULO_HOME='/var/lib/accumulo'

3. export ACCUMULO_HOME

It will set $ACCUMULO_HOME

Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

RickRock — Thu, 03 May 2018 05:28:11 GMT

Its working thanks

@Tanuj83wrote:
Hi
You can use the following commands:
1. sudo mkdir /var/lib/accumulo
2. ACCUMULO_HOME='/var/lib/accumulo'
3. export ACCUMULO_HOME

It will set $ACCUMULO_HOME

its working for me now ....Thanks

Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

urssanj00 — Thu, 16 Aug 2018 22:35:29 GMT

Try below. I found ACCUMULO libs in /usr/lib/hive/lib so decided to set below and it worked. Now sqoop is not giving any warning.

ACCUMULO_HOME=/usr/lib/hive
export ACCUMULO_HOME

Re: Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail

Uchenna — Wed, 19 Oct 2022 16:04:42 GMT

How do I put the sql connector jar in /var/lib/sqoop?

Thanks