title: Hive create query with timestamp having format AM/PM
body: <p>I have a file with only one date column which contains date in format <strong>'10/2/2017  10:56:00 AM'</strong></p>
  
  <p>I want to create a external hive table on this file but due to the AM/PM format hive timestamp is not able to recognize it, any pointers to this?</p>