Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Fri, 22 Sep 2017 16:58:00 +0000 (UTC)
From: "Vitalii Diravka (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.13058751.1490307103000.177779.1506099480520@Atlassian.JIRA>
In-Reply-To: <JIRA.13058751.1490307103000@Atlassian.JIRA>
References: <JIRA.13058751.1490307103000@Atlassian.JIRA> <JIRA.13058751.1490307103252@jira-lw-us.apache.org>
Subject: [jira] [Updated] (DRILL-5377) Five-digit year dates are displayed
 incorrectly via jdbc
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Fri, 22 Sep 2017 16:58:04 -0000


     [ https://issues.apache.org/jira/browse/DRILL-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vitalii Diravka updated DRILL-5377:
-----------------------------------
    Priority: Minor  (was: Major)

> Five-digit year dates are displayed incorrectly via jdbc
> --------------------------------------------------------
>
>                 Key: DRILL-5377
>                 URL: https://issues.apache.org/jira/browse/DRILL-5377
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Parquet
>    Affects Versions: 1.10.0
>            Reporter: Rahul Challapalli
>            Assignee: Vitalii Diravka
>            Priority: Minor
>             Fix For: 1.12.0
>
>
> 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
> {code}
> 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
> {code}
> Or a simpler case:
> {code}
> 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)
> {code}


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)