说明：
Sqoop(发音：skup)是一款开源的工具，主要用于在Hadoop(Hive)与传统的数据库(mysql、postgresql...)间进行数据的传递，可以将一个关系型数据库（例如 ： MySQL ,Oracle ,Postgres等）中的数据导进到Hadoop的HDFS中，也可以将HDFS的数据导进到关系型数据库中。Sqoop依赖于hadoop
一、安装介质
安装包：sqoop-1.4.4.bin__hadoop-2.0.4-alpha.tar.gz
二、解压安装介质
[root@hadoop-server01 apps]# tar -xvf sqoop-1.4.4.bin__hadoop-2.0.4-alpha.tar.gz -C /usr/local/apps/
三、修改配置文件
这里只需要修改sqoop-env.sh文件即可
#cd /usr/local/apps/sqoop-1.4.4.bin__hadoop-2.0.4-alpha/conf
[root@hadoop-server01 conf]# mv sqoop-env-template.sh sqoop-env.sh
[root@hadoop-server01 conf]# vi sqoop-env.sh
#Set path to where bin/hadoop is available
export HADOOP_COMMON_HOME=/usr/local/apps/hadoop-2.4.1
#Set path to where hadoop-*-core.jar is available
export HADOOP_MAPRED_HOME=/usr/local/apps/hadoop-2.4.1
#set the path to where bin/hbase is available
export HBASE_HOME=/usr/local/apps/hbase-0.96.2-hadoop2
#Set the path to where bin/hive is available
export HIVE_HOME=/usr/local/apps/hive-0.12.0-bin
#Set the path for where zookeper config dir is
export ZOOCFGDIR=/usr/local/apps/zookeeper-3.4.5/conf
四、配置环境变量
export SQOOP_HOME=/usr/local/apps/sqoop-1.4.4.bin__hadoop-2.0.4-alpha
export PATH=$PATH:$ZK_HOME/bin:$HBASE_HOME/bin:$HIVE_HOME/bin:$SQOOP_HOME/bin
五、验证命令
[root@hadoop-server01 ~]# sqoop help
Warning: /usr/lib/hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
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
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
为此，sqoop安装配置完成
