title: Stopping hive from writing temp files to s3
body: <p>How do I stop Hive from writing temporary files to s3 when doing an INSERT OVERWRITE TABLE  query.</p>
  
  <p>I found a property in hive-default.xml </p>
  
  <pre><code>&lt;property&gt;
      &lt;name&gt;hive.exec.skips3scratch&lt;/name&gt;
      &lt;value&gt;true&lt;/value&gt;
      &lt;description&gt;Do not write temp files to S3 scratch space. This will
          increase the performance by avoiding multiple writes in S3, but can
          corrupt the table or partition being written to, esp. if the job
          fails.
      &lt;/description&gt;
  &lt;/property&gt;
  </code></pre>
  
  <p>I set this in hive-site.xml, but it still seems to write temp files to s3.</p>
  
  <p>Is there something that I am missing?</p>