search

concurrencylabs / aws-cost-analysis

Tools that make it easier to analyze AWS Cost and Usage reports. Initial version provides support for Athena and QuickSight.
GNU General Public License v3.0
173 stars 43 forks source link

Athena date_parse error - malformed error #17

Open satishrandive opened 2 years ago

satishrandive commented 2 years ago

hi,

Can someone please assist to resolve following error -

An error occurred while loading the data. [Simba]AthenaJDBC An error has been thrown from the AWS Athena client. INVALID_FUNCTION_ARGUMENT: Invalid format: "04-apr-2022" is malformed at "apr-2022"

I am trying to convert the string to date format

sample string - 16-apr-2022 10-may-2022 06-apr-2022

code ( used in select clause)- date_parse("date_string"."date",'%d-%m-%y') as New_date

Thank you