title: Passing date as command line arguments in Hive
body: <p>I have my below query in <code>test1.hql file</code>. I am trying to pass the <code>date (dt)</code> as the command line argument.</p>
  
  <pre><code>select * from lip_data_quality where dt = '${hiveconf: start_date}';
  </code></pre>
  
  <p>So whenever I try to run the above <code>test1.hql</code> file from shell prompt like this-</p>
  
  <pre><code> hive -f hivetest1.hql -hiveconf start_date=20120709
  </code></pre>
  
  <p>I get zero records back. But the data is there in that table for that particular date. Why is it so? Something wrong I am doing?</p>
  
  <p>Can anyone help me out here? I was following <a href="http://kickstarthadoop.blogspot.com/2011/10/include-values-during-execution-time-in.html">Bejoy's Article</a></p>
  
  <p>I am working <code>Hive 0.6</code></p>