Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5377

Five-digit year dates are displayed incorrectly via jdbc

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Not A Problem
    • Affects Version/s: 1.10.0
    • Fix Version/s: 1.13.0
    • Component/s: Storage - Parquet
    • Labels:
      None

      Description

      git.commit.id.abbrev=38ef562

      The issue is connected to displaying five-digit year dates via jdbc
      Below is the output, I get from test framework when I disable auto correction for date fields

      select l_shipdate from table(cp.`tpch/lineitem.parquet` (type => 'parquet', autoCorrectCorruptDates => false)) order by l_shipdate limit 10;
      
      ^@356-03-19
      ^@356-03-21
      ^@356-03-21
      ^@356-03-23
      ^@356-03-24
      ^@356-03-24
      ^@356-03-26
      ^@356-03-26
      ^@356-03-26
      ^@356-03-26
      

      Or a simpler case:

      0: jdbc:drill:> select cast('11356-02-16' as date) as FUTURE_DATE from (VALUES(1));
      +--------------+
      | FUTURE_DATE  |
      +--------------+
      | 356-02-16   |
      +--------------+
      1 row selected (0.293 seconds)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vitalii Vitalii Diravka
                Reporter:
                rkins Rahul Challapalli
                Reviewer:
                Paul Rogers
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: