Hive : sort data based on a string field that has date in (dd/mm/yy) format


#1

Hi,

How to sort data based on a string field that has date in (dd/mm/yy) format in hive?
Example:
i/p data:
select d from date_sort;
11/10/90
01/10/89
01/03/89
01/03/92
28/04/92

I need to sort this by date.
required o/p:
01/03/89
01/10/89
11/10/90
01/03/92
28/04/92

Thanks,
Shilpa