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 in Big Data Hadoop by Kiran
30 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 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,010 points
41 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 3, 2018 in Big Data Hadoop by Vardhan
• 11,490 points
55 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
• 67,120 points
59 views
0 votes
1 answer

Sqoop getting error while connecting to MySQL

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

answered Feb 7 in Big Data Hadoop by Omkar
• 67,120 points
34 views
0 votes
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
• 10,110 points
2,048 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
• 10,110 points
196 views
0 votes
10 answers

hadoop fs -put command?

copy command can be used to copy files ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Sujay
10,478 views
0 votes
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,240 points
764 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 in Big Data Hadoop by Raj
21 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 in Big Data Hadoop by Yogi
24 views