Github user paul-rogers commented on the issue:
https://github.com/apache/drill/pull/916
Other than dealing with corrupted dates from Parquet, what other uses of
five digit years are expected? Few business processes project 8,000 years into
the future. Scientific projects are likely to project far more than just 10,000
years into the future; they would need to handle billions of years (death of
the sun) to trillions (heat death of the universe.) By contrast, 8000 years ago
were civilizations that we no know only from a few archeological remains. Few
business records extend that far back.
So, if not for corrupt Parquet dates, what is the use case for 5-digit
years? Why is Drill the only tool needing such dates? If they were common,
wouldn't `java.sql.Date`, SQL, the ISO standard and other mechanisms define the
rules?
---
