drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From paul-rogers <...@git.apache.org>
Subject [GitHub] drill issue #916: DRILL-5377: Five-digit year dates are displayed incorrectl...
Date Wed, 13 Sep 2017 18:07:03 GMT
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?


---

Mime
View raw message