Friday, 5 February 2016

Sqoop Installation



1.Download Your Scoop tar file in apache link

                http://www.eu.apache.org/dist/sqoop/


2.Extract the tar file and move your path

               mv sqoop2.6.1   /opt/sqoop/

3.Set the Environment in .bashrc file

my Sqoop path is :'/opt/Sqoop/sqoop-1.4.6.bin__hadoop-2.0.4-alpha'


export SQOOP_HOME='/opt/Sqoop/sqoop-1.4.6.bin__hadoop-2.0.4-alpha'
export PATH=$PATH:$SQOOP_HOME/bin


4.Check if the sqoop has been installed successfully type the command

                 sqoop version

Warning: /opt/Sqoop/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /usr/hdp/2.2.0.0-2041/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
2016-02-06 13:21:28,496 INFO  [main] sqoop.Sqoop: Running Sqoop version: 1.4.6
Sqoop 1.4.6

git commit id c0c5a81723759fa575844a0a1eae8f510fa32c25
Compiled by root on Mon Apr 27 14:38:36 CST 2015





5 . Finally  Type below command in  command prompt
                  
                  sqoop help

arning: /opt/Sqoop/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /usr/hdp/2.2.0.0-2041/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
2016-02-06 13:21:54,687 INFO  [main] sqoop.Sqoop: Running Sqoop version: 1.4.6
usage: sqoop COMMAND [ARGS]

Available commands:
  codegen            Generate code to interact with database records
  create-hive-table  Import a table definition into Hive
  eval               Evaluate a SQL statement and display the results
  export             Export an HDFS directory to a database table
  help               List available commands
  import             Import a table from a database to HDFS
  import-all-tables  Import tables from a database to HDFS
  import-mainframe   Import datasets from a mainframe server to HDFS
  job                Work with saved jobs
  list-databases     List available databases on a server
  list-tables        List available tables in a database
  merge              Merge results of incremental imports
  metastore          Run a standalone Sqoop metastore
  version            Display version information

See 'sqoop help COMMAND' for information on a specific command.



Sucessfully installed Sqoop.


My HADOOP VERSION IS :  Hadoop 2.6.0

No comments:

Post a Comment