Sqoop installation on Linux

0 votes
Hey. I need to import SQL tables in Sqoop but Sqoop is not installed on my System. I am using Ubuntu. Please tell me how to install Sqoop.
Feb 26, 2019 in Big Data Hadoop by Siri
1,220 views

1 answer to this question.

0 votes

Before installing Sqoop, make sure Hadoop is installed.

To install Sqoop follow the below steps:

Open the terminal and download the sqoop archive:

$ wget http://mirrors.estointernet.in/apache/sqoop/1.4.7/sqoop-1.4.7.tar.gz

This will download the Sqoop archive. Now extract the Sqoop files:

$ tar -xvf sqoop-1.4.7.tar.gz

Now you have to set Sqoop Environment Variables in .bashrc file.

$ export SQOOP_HOME=/home/edureka/sqoop-1.4.7 export PATH=$PATH:$SQOOP_HOME/bin

Now you have to configure Sqoop. Follow the below steps to do this:

$ cd $SQOOP_HOME/conf
$ mv sqoop-env-template.sh sqoop-env.sh

Now open the sqoop-env.sh file with a text editor

$ nano sqoop-env.sh

and add the path to Hadoop:

The path might change depending on where you have stored Hadoop. Use the path applicable to you.

Save (Ctrl+o) and exit (Ctrl+x)

Next step is to configure the mysql connector.

Run the below commands to do it:

$ wget http://ftp.ntu.edu.tw/MySQL/Downloads/Connector-J/mysql-connector-java-8.0.15.tar.gz

$ tar -xvf mysql-connector-java-8.0.15.tar.gz

$ mv mysql-connector-java-8.0.15/mysql-connector-java-8.0.15.jar /$SQOOP_HOME/lib

Finally, to verify the installation, run:

$ sqoop -version

This will output version about sqoop

25/2/19 18:52:32 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5
Sqoop 1.4.5 git commit id 5b34accaca7de251fc91161733f906af2eddbe83
Compiled by abe on Fri Aug 1 11:19:26 PDT 2014
answered Feb 26, 2019 by Kriti

Related Questions In Big Data Hadoop

0 votes
1 answer

Sqoop installation on Linux

Before installing Sqoop, make sure Hadoop is ...READ MORE

answered Feb 26, 2019 in Big Data Hadoop by Suman
5,506 views
0 votes
1 answer

Hive installation on Linux

Download hive from: http://www.apache.org/dyn/closer.cgi/hive/ Extract the files using ...READ MORE

answered Feb 28, 2019 in Big Data Hadoop by Mahesh
1,238 views
+1 vote
1 answer

Hadoop Installation Issue on Windows

Below is the main error you are ...READ MORE

answered Mar 26, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
6,234 views
0 votes
1 answer

Hadoop installation issue on fedora 24

type jps and check whether namenode and datanode is ...READ MORE

answered Jan 24, 2019 in Big Data Hadoop by Frankie
• 9,830 points
805 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,931 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,457 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
108,353 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,550 views
0 votes
1 answer

Installing Pig on Linux System

It was a good thing that you ...READ MORE

answered Feb 27, 2019 in Big Data Hadoop by Yuri
972 views
0 votes
1 answer

How to install HBase on Linux?

To install Hbase, you first need the ...READ MORE

answered Feb 27, 2019 in Big Data Hadoop by Tanisha
4,793 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