title: To create column with date datatype in hive table
body: <p>I have created table in HIVE(0.10.0) using values :</p>
  
  <pre><code>2012-01-11  17:51   Stockton    Children's Clothing     168.68  Cash
  2012-01-11  17:51   Tampa       Health and Beauty       441.08  Amex
  ............
  </code></pre>
  
  <p>Here date and time are tab separated values and  I need to work on date column, Since Hive doesn't allow "date" datatype ,I have used "TIMESTAMP" for first date column(2012-01-11,...),
   however after creating table it is showing NULL values for first column.</p>
  
  <p>How to solve this? Please guide.</p>