title: oracle and hive timestamp
body: <p>I have a vendor oracle DB storing values to a column <code>creation_timestamp</code> as <code>timestamp(6)</code> when i create an extract of that table and load it to HDFS and create hive schema with that column defined as <code>timestamp</code> it does not populate the field.  However if I use <code>string</code> it is all there.  I have other MSSQL <code>datetime</code> data that successfully stored as <code>timestamp</code> in hive so I am just a little unsure why the oracle <code>timestamp</code> data is not populating.</p>
  
  <p>The oracle timestmap looks like this: <code>07-JAN-15 05.55.20.732754000 PM</code>
  I have a feeling hive does not like the month as letters as the documentation states:<code>Strings: JDBC compliant java.sql.Timestamp format "YYYY-MM-DD HH:MM:SS.fffffffff" (9 decimal place precision)</code></p>
  
  <p><b>How can I convert the oracle <code>timestamp(6)</code>:<code>07-JAN-15 05.55.20.732754000 PM</code> to the <code>java.sql.Timestamp format</code> shown above?  </b></p>