sqoop2导入mysql到HDFS时报错：java.lang.NoClassDefFoundError: org/json/JSONObject

1. 解压并安装

tar xvfz sqoop-1.99.6-bin-hadoop200.tar.gz 

1. mv sqoop-1.99.6-bin-hadoop200 sqoop/

2. chmod -R 775 sqoop/

3. chown -R zhu sqoop/

1. 修改环境变量

1. zhu@Master:~$ sudo vim /etc/profile

2. #sqoop

3. export SQOOP_HOME=$HOME/sqoop

4. export PATH=$SQOOP_HOME/bin:$PATH

5. export CATALINA_BASE=$SQOOP_HOME/server

6. export LOGDIR=$SQOOP_HOME/logs

7. hadoop@Master:~$ source /etc/profile

8.  

1. 修改sqoop的环境变量

1. zhu@Master:/$ sudo vim /home/zhu/sqoop/server/conf/sqoop.properties

2. #修改指向我的hadoop安装目录

3. org.apache.sqoop.submission.engine.mapreduce.configuration.directory= /home/zhu/hadoop/etc/hadoop

4. #catalina.properties

5. zhu@Master:/$ sudo vim /home/zhu/sqoop/server/catalina.properties

6. common.loader=/home/zhu/hadoop/share/hadoop/common/*.jar,/home/zhu/hadoop/share/hadoop/common/lib/*.jar,/home/zhu/hadoop/share/hadoop/hdfs/*.jar,/home/zhu/hadoop/share/hadoop/hdfs/lib/*.jar,/home/zhu/hadoop/share/hadoop/mapreduce/*.jar,/home/zhu/hadoop/share/hadoop/mapreduce/lib/*.jar,/home/zhu/hadoop/share/hadoop/tools/*.jar,/home/zhu/hadoop/share/hadoop/tools/lib/*.jar,/home/zhu/hadoop/share/hadoop/yarn/*.jar,/home/zhu/hadoop/share/hadoop/yarn/lib/*.jar,/home/zhu/hadoop/share/hadoop/httpfs/tomcat/lib/*.jar,

下载mysql驱动包，mysql-connector-java-5.1.27.jar
把jar包丢到到$SQOOP_HOME/server/lib下面

sudo cp mysql-connector-java-5.1.27.jar $SQOOP_HOME/server/lib

有时，启动sqoop时可能会遇到找不到JAVA_HOME的情况，为了保险起见我们直接在配置文件中写入JAVA_HOME
在/home/zhonglan/sqoop/bin/sqoop.sh中，添加

1. export JAVA_HOME=/usr/local/java

2. HADOOP_COMMON_HOME=/home/zhu/hadoop/share/hadoop/common

3. HADOOP_HDFS_HOME=/home/zhu/hadoop/share/hadoop/hdfs

4. HADOOP_MAPRED_HOME=/home/zhu/hadoop/share/hadoop/mapreduce

5. HADOOP_YARN_HOME=/home/zhu/hadoop/share/hadoop/yarn

6.  

1. 启动sqoop
   sqoop.sh server start
2. 验证启动成功

1. ./sqoop.sh server start 启动

2. ./sqoop.sh server stop 停止

3. ./sqoop.sh client 进入客户端

   <