title: Hive - Using date_add in a where clause
body: <p>I have a table that is partitioned by date. To query the last 10 days of data I usually write something that looks like: </p>
  
  <pre><code>SELECT * FROM table WHERE date = date_add(current_date, -10);
  </code></pre>
  
  <p>A coworker said this makes the query less efficient that using a simple date string. Is this the case? Can some explain this to me? Is there a way to write a dynamic date into the where clause that is efficient?</p>