I have a CSV file having Orderdate as string in it. In Amazon Atena trying to use dateparse to convert the format of data but getting error. This is what i am trying:
select parse_datetime(orderdate,'%m/%d/%y %H:%i:%s') from orders
Error: INVALID_FUNCTION_ARGUMENT: Invalid format: "9/1/2015 15:43"