mkdir /app
cd /opt
tar -zxvf sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz -C /app
cd /app
mv sqoop-1.4.7.bin__hadoop-2.6.0/ sqoop
vi /etc/profile vi操作:i(写入)完成后ESC键 加 :wq (保存退出)
在末尾添加以下两行代码;
export SQOOP_HOME=/app/sqoop
export PATH=$PATH:$SQOOP_HOME/bin
source /etc/profile
cd /app/sqoop/conf
mv sqoop-env-template.sh sqoop-env.sh
vi sqoop-env.sh
在末尾添加
export HADOOP_COMMON_HOME=/usr/local/hadoop
export HADOOP_MAPRED_HOME=/usr/local/hadoop
export HIVE_HOME=/hive-2.3.2
cd /opt
tar -zxvf mysql-connector-java-5.1.45.tar.gz
cp mysql-connector-java-5.1.45/mysql-connector-java-5.1.45-bin.jar /app/sqoop/lib/
sqoop list-databases -connect jdbc:mysql://localhost:3306/ --username root --password 123123
sqoop list-databases -connect jdbc:mysql://localhost:3306/ --username root --password 123123 > /app/log.txt