Dear Hive User! In Hive the standard date format is YYYY-MM-DD, like “2024-09-17”. So when casting a string which format is different, like DD-MM-YYYY e.g. “17-09-2024" to date, *as a* *Hive user *what would you expect as a result?
1. “0017-09-20” => Year of 17 September 20 or 2. null It is possible to give a date pattern CAST(<string-value> AS DATE FORMAT <date-pattern>)and cast with it like "DD-MM-YYYY". Earlier it gave back null, but currently Hive gives back the first, which I think unexpected as a user and customers complain about that. There is a debate if it is a bug or feature, so I need your help! *I would like to ask you to reply with a vote on 1 or 2 what you want as a user to happen!* I really appreciate your input! Thank you, Zoltan Ratkai
