Installation of Sqoop

Our HadoopTpoint App is now available in google play store,please rate and comment it in play store : W3Schools

 Installation of sqoop:

Installation of sqoop is very easy.In the process  installation of sqoop no need to update the sqoop-site.xml for basic sqoop commands.Just download the sqoop installation tar file from apache mirrors,then copy it into specified directory,and then extract it,finally update the bashrc file.

Sqoop is used to transfer data between Hadoop and relational databases or mainframes. You can use Sqoop to .import data from a relational database management system (RDBMS) such as MySQL or Oracle or a mainframe into the Hadoop Distributed File System (HDFS), transform the data in Hadoop MapReduce, and then export the data back into an RDBMS.

Sqoop Installation Steps:

  1.   Download the sqoop tar zip from apache mirrors

                  http://mirror.fibergrid.in/apache/sqoop/1.4.6/

  1.  Copy into specified work directory (like other frameworks pig,hive) and then extract it.

 

  1.   update the bashrc file

               export SQOOP_HOME=/home/hadoop/work/sqoop-1.4.6

               export PATH=$SQOOP_HOME/bin

              For Other Frameworks environment variables.

 export JAVA_HOME=/usr/lib/jvm/java-1.6.0-openjdk

export HADOOP_HOME=/home/hadoop/work/hadoop-2.6.0

export HADOOP_COMMON_HOME=$HADOOP_HOME

export HADOOP_HDFS_HOME=$HADOOP_HOME

export HADOOP_MAPRED_HOME=$HADOOP_HOME

export YARN_HOME=$HADOOP_HOME

export HADOOP_CONF_DIR=$HADOOP_HOME/etc/hadoop

export YARN_CONF_DIR=$HADOOP_HOME/etc/hadoop

export HIVE_HOME=/home/hadoop/work/apache-hive-0.14.0-bin

export HBASE_HOME=/home/hadoop/work/hbase-0.94.8

export SQOOP_HOME=/home/hadoop/work/sqoop-1.4.6

export PATH=$JAVA_HOME/bin:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$HIVE_HOME/bin:$HBASE_HOME/bin:$SQOOP_HOME/bin:$PATH

 These three steps enough to installation of sqoop.

 

Speak Your Mind

*