I'm finding the parsing of dates in the Second SQL Hands-On Prepare Recipe to be a bit odd.
https://academy.dataiku.com/dataiku-dss-sql-1/500835
In the video I see that the Date format(s) selected was
yyyy/HH/mm (Year/Hour in day/Minute in hour)
In my mind birthdays are typically:
yyyy/MM/dd (Year/Month in year/Day in month)
And in fact, when I choose the format that makes sense to me there are four records that do not parse for Leap year problems.
[11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1965/2/29' using format 'yyyy/MM/dd': Cannot parse "1965/2/29": Value 29 for dayOfMonth must be in the range [1,28] [11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1965/2/29' using format 'yyyy/MM/dd': Cannot parse "1965/2/29": Value 29 for dayOfMonth must be in the range [1,28] [11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1993/2/29' using format 'yyyy/MM/dd': Cannot parse "1993/2/29": Value 29 for dayOfMonth must be in the range [1,28] [11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1993/2/29' using format 'yyyy/MM/dd': Cannot parse "1993/2/29": Value 29 for dayOfMonth must be in the range [1,28] [11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1993/2/29' using format 'yyyy/MM/dd': Cannot parse "1993/2/29": Value 29 for dayOfMonth must be in the range [1,28]
Is this a thing? Are there places in the world that show birthdates as:
(Year/Hour in day/Day in Month)?
Below is a frame from the video:
Hi! That's an error in the video and it should be yyyy/MM/dd. Thanks for catching this.
Thanks.