Impala: convert dd-MMM-yy string to yyyy-mm-dd

I'm receiving a csv with dates in a dd-MMM-yy format, e.g. 29-aug-17 I want to convert them into yyyy-MM-dd, e.g. 2017-08-29 It could be just me not having googled the correct function, but I can't find anything to cope with the MMM way ...
more »

2017-09-11 17:09 (2) Answers