title: how to add date to number in hive
body: <p>I want to perform addition on date field and int field.</p>
  
  <p>I am executing the below query. It's throwing the error. I am not able to add. In this <code>create_date</code> is DATE data type and <code>duration</code> is INT data type.</p>
  
  <pre><code>SELECT (create_date+duration)
  FROM course;
  </code></pre>
  
  <p>Please help me.</p>
  
  <p>Thanks</p>