安裝sqoop1.99.7

sqoop2和sqoop1有較大的區別。將整體的ETL過程分割成server和client兩部分執行，sqoop2是交互式的操作。

解壓安裝

[hadoop@fa01 ~]$ tar -zxvf sqoop-1.99.7-bin-hadoop200.tar.gz -C ./

重命名

[hadoop@fa01 ~]$ mv sqoop-1.99.7-bin-hadoop200 sqoop-1.99.7

同時新建一個extra文件，放置mysql的驅動文件（文件名隨意，配置文件相對應上就可以）

[hadoop@fa01 sqoop-1.99.7]$ mkdir extra

[hadoop@fa01 ~]$ mv mysql-connector-java-5.1.5-bin.jar /home/hadoop/sqoop-1.99.7/extra/

配置環境變量。配置sqoop第三方jar包引用變量

[hadoop@fa01 ~]$ vim .bash_profile

export SQOOP_HOME=/home/hadoop/sqoopsqoop-1.99.7

export SQOOP_SERVER_EXTRA_LIB=/home/hadoop/sqoop-1.99.7/extra

修改hadoop的core-site.xml文件，這里的hadoop為用戶名

[hadoop@fa01 ~]$ cd hadoop-2.6.0-cdh6.5.2/etc/hadoop

[hadoop@fa01 hadoop]$ vim core-site.xml

<property>

<name>hadoop.proxyuser.hadoop.hosts</name>

<value>*</value>

</property>

<property>

<name>hadoop.proxyuser.hadoop.groups</name>

<value>*</value>

</property>

配置sqoop里的conf文件里面的# Hadoop configuration directory

[hadoop@fa01 ~]$ cd sqoop-1.99.7/conf/

[hadoop@fa01 conf]$ vim sqoop.properties

org.apache.sqoop.submission.engine.mapreduce.configuration.directory=/home/hadoop/hadoop-2.6.0-cdh6.5.2/etc/hadoop

檢查sqoop是否配置成功

[hadoop@fa01 bin]$ ./sqoop2-tool verify

Setting conf dir: /home/hadoop/sqoop-1.99.7/bin/../conf

Sqoop home directory: /home/hadoop/sqoop-1.99.7

Sqoop tool executor:

Version: 1.99.7

Revision:435d5e61b922a32d7bce567fe5fb1a9c0d9b1bbb

Compiled on Tue Jul 19 16:08:27 PDT 2016 by abefine

Running tool: class org.apache.sqoop.tools.tool.VerifyTool

2017-06-21 01:31:48,489 INFO  [main] core.SqoopServer (SqoopServer.java:initialize(55)) - Initializing Sqoop server.

2017-06-21 01:31:48,539 INFO  [main] core.PropertiesConfigurationProvider (PropertiesConfigurationProvider.java:initialize(99)) - Starting config file poller thread

Verification was successful.

Tool class org.apache.sqoop.tools.tool.VerifyTool has finished correctly.

啟動sqoop

[hadoop@fa01 bin]$ ./sqoop2-server start

Setting conf dir: /home/hadoop/sqoop-1.99.7/bin/../conf

Sqoop home directory: /home/hadoop/sqoop-1.99.7

Starting the Sqoop2 server...

2017-06-21 01:32:31,088 INFO  [main] core.SqoopServer (SqoopServer.java:initialize(55)) - Initializing Sqoop server.

2017-06-21 01:32:31,100 INFO  [main] core.PropertiesConfigurationProvider (PropertiesConfigurationProvider.java:initialize(99)) - Starting config file poller thread

Sqoop2 server started.