[DRILL-5377] Five-digit year dates are displayed incorrectly via jdbc

• 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
• Assignee: Vitalii Diravka
• Reporter: Rahul Kumar Challapalli
• Reviewer: Paul Rogers
• Created: 23/Mar/17 22:11
• Updated: 27/Sep/19 18:21
• Resolved: 31/Jan/18 15:26

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)

Issue Links

• relates to: CALCITE-2055 Check year, month, day, hour, minute and second ranges for date and time literals
• links to: GitHub Pull Request #916