Sqoop is a tool used to transfer data from Hadoop and relational databases to each other in a relational database (e.g. MySQL, Oracle, Postgres, etc.) into the HDFs of Hadoop. HDFs data can also be directed into a relational database.
1. Download a version of Sqoop2 Sqoop-1.99.6-bin-hadoop200.tar
2. Unzip to/usr/local/sqoop3, modify the catalina.properties in the file server/conf, modify the Common.loader property,all the jar packages in the share folder under the Hadoop installation folder are introduced. thatcommon.loader=${catalina.base}/lib,${catalina.base}/lib/*.jar,${catalina.home}/lib,${catalina.home}/lib/*. jar,${catalina.home}/. /lib/*.jar,/usr/lib/hadoop/*.jar,/usr/lib/hadoop/lib/*.jar,/usr/lib/hadoop-hdfs/*.jar,/usr/lib/hadoop-hdfs/lib /*.jar,/usr/lib/hadoop-mapreduce/*.jar,/usr/lib/hadoop-mapreduce/lib/*.jar,/usr/lib/hadoop-yarn/*.jar,/usr/lib /hadoop-yarn/lib/*.jar,/usr/lib/hive/lib/*.jar,
/usr/local/hadoop/share/hadoop/common/*.jar,
/usr/local/hadoop/share/hadoop/hdfs/*.jar,
/usr/local/hadoop/share/hadoop/httpfs/*.jar,
/usr/local/hadoop/share/hadoop/kms/*.jar/,
/usr/local/hadoop/share/hadoop/mapreduce/*.jar,
/usr/local/hadoop/share/hadoop/tools/*.jar,
/usr/local/hadoop/share/hadoop/yarn/*.jar 4, modify the environment variables, increase in the ~/.BASHRCExport Sqoop_home=/usr/local/sqoopExport path= $SQOOP _home/bin: $PATHexport catalina_home= $SQOOP _home/serverexport logdir= $SQOOP _home/logs 5, run sqoop2-tool Verify check the configuration file is correct. (I'm running a bunch of bugs and I'm not looking carefully) 6. Starting Sqoop server:sqoop2-server start 7, Start Sqoop client, enter the shell environment:Sqoop2-shellClient connection to server: Set server--host 127.0.0.1--port 12000--webapp sqoopBrowser can be viewed on port 12000. Server failed to run successfully, Port 12000 could not be viewed.
Run Sqoop2 failed to start