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.
文章题目:安装sqoop1.99.7
网址分享:https://www.cdcxhl.com/article14/jieede.html
成都网站建设公司_创新互联,为您提供软件开发、网站营销、用户体验、标签优化、网站排名、关键词优化
声明:本网站发布的内容(图片、视频和文字)以用户投稿、用户转载内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。电话:028-86922220;邮箱:631063699@qq.com。内容未经允许不得转载,或转载时需注明来源: 创新互联