安裝Sqoop的前提是已經(jīng)具備Java和Hadoop的環(huán)境几迄,為后續(xù)的測試,最好也安裝好Hive青柄、HBase伐债、Zookeeper、Mysql
1致开、下載地址
http://mirrors.hust.edu.cn/apache/sqoop
2峰锁、上傳安裝包
sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz到虛擬機中
3、解壓sqoop安裝包到指定目錄
[victor@node1 software]$ tar -xzvf sqoop-1.4.7.bin_hadoop-2.6.0.tar.gz -C /opt/module
4双戳、修改配置文件
[victor@node1 software]$ cd /opt/module/sqoop-1.4.7/conf
[victor@node1 conf]$ pwd
/opt/module/sqoop-1.4.7/conf
[victor@node1 conf]$ cp sqoop-env-template.sh sqoop-env.sh
[victor@node1 conf]$ cp sqoop-site-template.xml sqoop-site.xml
[victor@node1 conf]$ vim sqoop-env.sh
export HADOOP_COMMON_HOME=/opt/module/hadoop-2.8.2
export HADOOP_MAPRED_HOME=/opt/module/hadoop-2.8.2
export HBASE_HOME=/opt/module/hbase-1.2.5
export HIVE_HOME=/opt/module/apache-hive-1.2.5-bin
export ZOOKEEPER_HOME=/opt/module/zookeeper-3.4.10
export ZOOCFGDIR=/opt/module/zookeeper-3.4.10
#尖叫提示:ZOOKEEPER_HOME官方默認沒有虹蒋,不配置 sqoop啟動報錯
5、拷貝jdbc驅動到sqoop的lib目錄下
[victor@node1 conf]$ cp -a mysql-connector-java-5.1.27-bin.jar /opt/module/sqoop-1.4.7/lib/
6飒货、驗證Sqoop
[victor@node1 sqoop-1.4.7]$ bin/sqoop help
(警告信息已省略)
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
7魄衅、測試Sqoop是否能夠成功連接數(shù)據(jù)庫
[victor@node1 sqoop-1.4.7]$ bin/sqoop list-databases \
--connect jdbc:mysql://node1:3306/ --username root --password 000000
##出現(xiàn)如下輸出
information_schema
metastore
mysql
performance_schema