Community Articles

Find and share helpful community-sourced technical articles.
Labels (2)


Following upgrade to 2.5 Oozie Sqoop job which previously worked now fails with

oozi-W@sqoop-aa6c] Launcher exception: org/json/JSONObject
java.lang.NoClassDefFoundError: org/json/JSONObject
                at org.apache.sqoop.util.SqoopJsonUtil.getJsonStringforMap(
                at org.apache.sqoop.SqoopOptions.writeProperties(
                at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.createInternal(
                at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.create(


Ensure that 'java-json.jar' file exists in the following locations: /usr/hdp/current/sqoop-client/lib /usr/hdp/<version>/sqoop/lib

Also copy this jar into HDFS and reference it in your oozie workflow:


hdfs dfs -put /usr/hdp/current/sqoop-client/lib/java-json.jar /user/oozie/oozie_scripts/lib/

and change workflow.xml:


Rising Star

Can you eloberate more details as i am facing same issue and when i checked it i see the java-json.jar in the oozie shared lib path, However, i don't see it in the sqoop-client/lib path on the gateway.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.
Version history
Last update:
‎02-08-2017 10:18 AM
Updated by:
Top Kudoed Authors