title: Hive "select to_date(column2) from tablename"
body: <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>