Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

Sqoop Installation


The prerequisite for Sqoop installation are Java and Hadoop. These two must be preinstalled in the system.

Download the latest version of Sqoop from internet. The following commands are used to extract the Sqoop tar ball and move it to “/usr/lib/sqoop” directory.

  1. $tar -xvf sqoop-1.4.4.bin__hadoop-2.0.4-alpha.tar.gz
  2. $ su
  3. password:
  4. # mv sqoop-1.4.4.bin__hadoop-2.0.4-alpha /usr/lib/sqoop
  5. #exit

Configure .bashrc file using the below command

  1. #export SQOOP_HOME=/usr/lib/sqoop export PATH=$PATH:$SQOOP_HOME/bin

Copy the template file

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

Edit sqoop-env.sh file with the lines below

  1. export HADOOP_COMMON_HOME=/usr/local/hadoop
  2. export HADOOP_MAPRED_HOME=/usr/local/hadoop

Download and set the mysql-connector-java using the commands below

  1. $ tar -zxf mysql-connector-java-5.1.30.tar.gz
  2. $ su
  3. password:
  4. # cd mysql-connector-java-5.1.30
  5. # mv mysql-connector-java-5.1.30-bin.jar /usr/lib/sqoop/lib

Type the below command to verify Sqoop installation

  1. $ cd $SQOOP_HOME/bin
  2. $ sqoop-version

Comments

comments