title: How to load file with time (Date) type into Hive table?
body: <p>I'm using hive to create and try to load file content into the table.
  There's a column type "Date" and the date format in the file is dd/mm/yy, for example: 01/12/2013</p>
  
  <p>But when I trie to load the data into table from the file, the column values corresponding to the "Date" is always NULL, as if failed to load the date content.</p>
  
  <p>I put the column content into a txt file and upload to the hdfs, so, the column may be:
  id, name, birthdate</p>
  
  <p>and corresponding value are:
  1, "Joan", 04/05/1989</p>
  
  <p>But the "04/05/1989" seems can't be read into the table, always null.</p>
  
  <p>Please tell me if the format in my txt file is wrong or I need some specific grammar when loading date type data into Hive table.</p>
  
  <p>Thanks!</p>