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 in Big Data Hadoop by Siri
91 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 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 25 in Big Data Hadoop by Suman
469 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 27 in Big Data Hadoop by Mahesh
99 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
• 10,670 points
729 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 in Big Data Hadoop by Frankie
• 9,810 points
44 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,670 points
2,677 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,670 points
279 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
13,283 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
975 views
0 votes
1 answer

Installing Pig on Linux System

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

answered Feb 27 in Big Data Hadoop by Yuri
38 views
0 votes
1 answer

How to install HBase on Linux?

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

answered Feb 27 in Big Data Hadoop by Tanisha
278 views