Apache Hive: How to convert string to timestamp?
<p>I'm trying to convert the string in <code>REC_TIME</code> column to a timestamp format in hive. </p>

<p>Ex: <em>Sun Jul 31 09:28:20 UTC 2016 <strong>=></strong> 2016-07-31 09:28:20</em> </p>

<pre><code>SELECT xxx, UNIX_TIMESTAMP(REC_TIME, "E M dd HH:mm:ss z yyyy") FROM wlogs LIMIT 10;
</code></pre>

<p>When I execute the above SQL it returns a NULL value.</p>