立即学习:https://edu.csdn.net/course/play/11032/239261?utm_source=blogtoedu
1.Sqoop安装部署
上传 解压 删除压缩包 创建软连接
进入配置目录
复制mv sqoop-env-template.sh sqoop-env.sh
进入编辑设置
export HADOOP_COMMON_HOME=/home/hadoop/app/hadoop
export HBASE_HOME=/home/hadoop/app/hbase
export HIVE_HOME=/home/hadoop/app/hive
export ZOOCFGDIR=/home/hadoop/app/zookeeper/conf
将mysql-connector-java-5.1.38.jar包上传/home/hadoop/app/sqoop-1.4.6-cdh5.10.0/lib
测试运行sqoop 启动mysql 密码进入(root)
sudo mysql -u root -p
grant all on *.* to 'root'@'localhost01' identified by 'xinfei182210';
flush privileges;
查看下
select host,user,password from mysql.user;
在sqoop目录下 查看下数据库
bin/sqoop list-databases --connect jdbc:mysql://localhost01/hive --username root --password 123456