https://community.cloudera.com/t5/Support-Questions/Sqoop-job-failing-with-DSQuotaExceededException/m-p/161788#M124167 <P>As an alternative, you can change scratchdir like so</P><P><A href="https://cwiki.apache.org/confluence/display/Hive/AdminManual+Configuration" target="_blank">https://cwiki.apache.org/confluence/display/Hive/AdminManual+Configuration</A></P><PRE>Using the set command in the CLI or Beeline for setting session level values for the configuration variable for all statements subsequent to the set command. For example, the following command sets the scratch directory (which is used by Hive to store temporary output and plans) to /tmp/mydir for all subsequent statements: set hive.exec.scratchdir=/tmp/mydir; Using the --hiveconf option of the hive command (in the CLI) or beeline command for the entire session. For example: bin/hive --hiveconf hive.exec.scratchdir=/tmp/mydir In hive-site.xml. This is used for setting values for the entire Hive configuration (see hive-site.xml and hive-default.xml.template below). For example: &lt;property&gt; &lt;name&gt;hive.exec.scratchdir&lt;/name&gt; &lt;value&gt;/tmp/mydir&lt;/value&gt; &lt;description&gt;Scratch space for Hive jobs&lt;/description&gt; &lt;/property&gt; </PRE> Fri, 17 Mar 2017 18:52:16 GMT aervits 2017-03-17T18:52:16Z