Getting error while using sqoop import

0 votes

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.
Jul 5, 2019 in Big Data Hadoop by Kiran
1,176 views

1 answer to this question.

0 votes

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

image

image

image

image

answered Jul 5, 2019 by Reshma

Related Questions In Big Data Hadoop

0 votes
1 answer

Getting error while building Hadoop core jar using ant.

I think you are missing libtool library. ...READ MORE

answered Apr 18, 2018 in Big Data Hadoop by coldcode
• 2,080 points
763 views
+3 votes
1 answer

Getting Connection Error while loading data into table using cloudera hive

Hey Nafeesa, Itseems that Hive is not able ...READ MORE

answered Oct 4, 2018 in Big Data Hadoop by Vardhan
• 13,190 points
697 views
0 votes
1 answer

Getting some warning/error while loading java file using Hbase commands

In your code, you have set some ...READ MORE

answered Dec 14, 2018 in Big Data Hadoop by Omkar
• 69,210 points
567 views
0 votes
1 answer

Sqoop getting error while connecting to MySQL

Have you set a password for MySQL? ...READ MORE

answered Feb 7, 2019 in Big Data Hadoop by Omkar
• 69,210 points
1,102 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
10,521 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
2,165 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
103,809 views
–1 vote
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,390 points
4,233 views
0 votes
1 answer

Issues using sqoop command while listing database

Please use the following command. sqoop list-databases --connect ...READ MORE

answered May 23, 2019 in Big Data Hadoop by Raj
872 views
0 votes
1 answer

How to decrease load on HBase while importing Sqoop?

Sqoop by default serializes all the input ...READ MORE

answered May 16, 2019 in Big Data Hadoop by Yogi
665 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP