Getting error while using sqoop import

Question

Hi Team,

I am using Edureka Cloud Lab. And I am running the command from Sqoop bin directory.

I am getting below error while executing scoop commands.Can I please get help in resolving this?

$sqoop
Warning: /opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set to the root of your Accumulo installation.

Answer 1

You are trying to execute the sqoop command from the bin directoty. Please note, that in Cloudlab, there is no need of executing the sqoop command from the bin directory. You can directly execute them from your user directory. Please refer to the below screenshot for your reference.

First create a table and insert data to it

 => use edureka;

=> create table student(name varchar(20));

=> insert into student values("kamini");

=> select * from student;


sqoop import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/edureka --table student --username labuser -P -target-dir /user/edureka_354973/output -m 1