title: Hive: how to convert millisecond timestamps?
body: <p>I am trying to use the <code>HIVE UDFs</code> (<a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions" rel="nofollow noreferrer">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions</a>) 
  from <code>Sparklyr</code> to read-in properly some timestamps. </p>
  
  <p>Unfortunately, I have not been able to parse correctly the following timestamp:</p>
  
  <pre><code>unix_timestamp('2011-03-01T00:00:04.226Z', 'yyyy-MM-ddThh:mm:ss.SSS' ) 
  </code></pre>
  
  <p>returns <code>NA</code>s..</p>
  
  <p>Any ideas? What is the right pattern here?
  THanks!</p>