SQOOP INSTALLATION
Step 1: Installing Sqoop
The following commands are used to
extract the Sqoop tar ball and move it to “/usr/lib/sqoop” directory.
$tar -xvf sqoop-1.4.4.bin__hadoop-2.0.4-alpha.tar.gz
$ su
password:
#
mv sqoop-1.4.4.bin__hadoop-2.0.4-alpha /usr/lib/sqoop
#exit
Step 2: Configuring bashrc
You have to set up the Sqoop
environment by appending the following lines to ~/.bashrc file:
#Sqoop
export SQOOP_HOME=/usr/lib/sqoop export PATH=$PATH:$SQOOP_HOME/bin
The following command is used to execute ~/.bashrc file.
$ source ~/.bashrc
Step 3: Configuring Sqoop
To configure Sqoop with Hadoop, you
need to edit the sqoop-env.sh file, which is placed in the $SQOOP_HOME/conf directory. First of all, Redirect to
Sqoop config directory and copy the template file using the following command:
$ cd $SQOOP_HOME/conf
$ mv sqoop-env-template.sh sqoop-env.sh
Open sqoop-env.sh and edit the following lines:
export
HADOOP_COMMON_HOME=/usr/local/hadoop
export HADOOP_MAPRED_HOME=/usr/local/hadoop
Step 4: Download and Configure
mysql-connector-java
The following commands are used to
extract mysql-connector-java tarball and move mysql-connector-java-5.1.30-bin.jar to /usr/lib/sqoop/lib directory.
$ tar -zxf mysql-connector-java-5.1.30.tar.gz
$ su
password:
#
cd mysql-connector-java-5.1.30
#
mv mysql-connector-java-5.1.30-bin.jar /usr/lib/sqoop/lib
Step 5: Verifying Sqoop
The following command is used to
verify the Sqoop version.
$ cd $SQOOP_HOME/bin
$
sqoop-version
Expected output:
15/12/17
14:52:32 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5
Sqoop
1.4.5 git commit id 5b34accaca7de251fc91161733f906af2eddbe83
Compiled
by abe on Fri Dec 1 11:19:26 PDT 2015
Sqoop installation is complete.
