title: how to parse a date from string in hive?
body: <p>I have some scv input data files, which look like this:</p>
  
  <pre><code>TicketID,AccountID,DateOpened
  1,acc-1,2015-10-29 T 10:45 UTC
  2,acc-2,2015-10-29 T 10:45 UTC
  3,acc-1,2015-10-30 T 10:45 UTC
  </code></pre>
  
  <p>Is there a way to have Hive parse the DateOpened field as a Date?</p>