title: how to manage Date interval in hive
body: <p>I'm new in Hive-Hadoop. I have some problem with Date interval management.</p>
  
  <p>In Postgresql, I can get the "6 days" before a given date :</p>
  
  <pre><code>select max(datejour) + INTERVAL '-6 day' as maxdate from table
  </code></pre>
  
  <p>e.g : if max(datejour) = 2015-08-22  ==> my query returns  2015-08-15</p>
  
  <p>Does somebody can help me on how could I do it in Hive?</p>
  
  <p>thanks. </p>