用sqoop从RDB导入数据到HDFS报错：Exception in thread “main“ java.lang.NoClassDefFoundError: org/json/JSONObject

用sqoop从RDB导入数据到HDFS

bin/sqoop-import \
 --connect jdbc:mysql://hadoop100:3306/hive \
 --driver com.mysql.jdbc.Driver \
 --table TBLS \
 --username root \
 --password ok \
 --target-dir /data/user \
 --m 3

出现报错

Exception in thread "main" java.lang.NoClassDefFoundError: org/json/JSONObject
        at org.apache.sqoop.util.SqoopJsonUtil.getJsonStringforMap(SqoopJsonUtil.java:43)
        at org.apache.sqoop.SqoopOptions.writeProperties(SqoopOptions.java:784)
        at org.apache.sqoop.mapreduce.JobBase.putSqoopOptionsToConfiguration(JobBase.java:392)
        at org.apache.sqoop.mapreduce.JobBase.createJob(JobBase.java:378)
        at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:256)
        at org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:692)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:513)
        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:621)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
Caused by: java.lang.ClassNotFoundException: org.json.JSONObject
        at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        ... 14 more

这是因为sqoop缺少java-json.jar包.，下载jar包导入sqoop目录下的lib目录下

• 下载wget工具

[root@hadoop100 lib]# yum install -y wget

• 使用wget工具下载jar包

[root@hadoop100 lib]# wget http://www.java2s.com/Code/JarDownload/java-json/java-json.jar.zip

• 下载unzip解压工具

[root@hadoop100 lib]# yum install -y unzip

• 解压java-json.jar.zip到lib目录下

[root@hadoop100 lib]# unzip java-json.jar.zip

用sqoop从RDB导入数据到HDFS

bin/sqoop-import \
 --connect jdbc:mysql://hadoop100:3306/hive \
 --driver com.mysql.jdbc.Driver \
 --table TBLS \
 --username root \
 --password ok \
 --target-dir /data/user \
 --m 3

这时代表数据导入成功