Hive "select to_date(column2) from tablename"
<p>I having the below table structure:</p>
<pre><code>Table name: test
</code></pre>
<p>Table Structure:col1 and col2 are Strings here.</p>
<div class="s-table-container">
<table class="s-table">
<thead>
<tr>
<th>col1</th>
<th>col2</th>
</tr>
</thead>
<tbody>
<tr>
<td>&quot;abc&quot;</td>
<td>&quot;15/04/2016&quot;</td>
</tr>
<tr>
<td>&quot;def&quot;</td>
<td>&quot;31/05/2016&quot;</td>
</tr>
</tbody>
</table>
</div>
<p>When I am trying to execute the below, it is showing NULL as the result.</p>
<pre><code>select to_date(col2) from test;
</code></pre>
<p>Any idea why it not showing the col2 result.</p>