hive casting date
<p>In a hive table I have bunch of date that are in integer format. </p>

<p>Example</p>

<p>Table</p>

<pre><code>Date
2015051517
2015051518
2015081517
</code></pre>

<p>Query</p>

<pre><code>SELECT CAST(date TO INT)
FROM date_table;
</code></pre>

<p>How do I get the above example like below?</p>

<pre><code>date
-------------
2015-05 15:17 
2015-05 15:18
2015-08 15:17
</code></pre>

<p>Thanks in advance!i</p>