Hive "select to_date(column2) from tablename"
I having the below table structure:
Table name: test
Table Structure:col1 and col2 are Strings here.
| col1 | col2 |
|---|---|
| "abc" | "15/04/2016" |
| "def" | "31/05/2016" |
When I am trying to execute the below, it is showing NULL as the result.
select to_date(col2) from test;
Any idea why it not showing the col2 result.