title: Convert unixtime to TIMESTAMP in HiveSQL
body: <p>How do I convert unix epoch time to TIMESTAMP in HiveSQL?</p>
  
  <p>The built-in date function <code>from_unixtime</code> is converting it to string and not TIMESTAMP. <code>to_utc_timestamp</code> only seem to convert timestamps from a timezone to UTC.</p>
  
  <p>Is there any function that converts directly from a unix timestamp as BIGINT to TIMESTAMP?</p>
  
  <p><strong>Example</strong></p>
  
  <pre><code>SELECT to_timestamp(1427976376) FROM mytable; --&gt; 2015-04-02 14:06:16
  </code></pre>
  
  <p><strong>EDIT:</strong></p>
  
  <p>The best option I can find, although not great, is </p>
  
  <pre><code>SELECT cast(from_unixtime(1427976376) as TIMESTAMP) FROM mytable;
  </code></pre>