You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/10/08 15:16:00 UTC
[jira] [Commented] (DRILL-6783) CAST string literal as INTERVAL
MONTH/YEAR works inconsistently when selecting from a table with multiple
rows
[ https://issues.apache.org/jira/browse/DRILL-6783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16641998#comment-16641998 ]
ASF GitHub Bot commented on DRILL-6783:
---------------------------------------
KazydubB opened a new pull request #1496: DRILL-6783: CAST string literal as INTERVAL MONTH/YEAR works inconsis…
URL: https://github.com/apache/drill/pull/1496
…tently when selecting from a table with multiple rows
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
> CAST string literal as INTERVAL MONTH/YEAR works inconsistently when selecting from a table with multiple rows
> --------------------------------------------------------------------------------------------------------------
>
> Key: DRILL-6783
> URL: https://issues.apache.org/jira/browse/DRILL-6783
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.15.0
> Reporter: Bohdan Kazydub
> Assignee: Bohdan Kazydub
> Priority: Critical
> Fix For: 1.15.0
>
>
> Casting string literal as INTERVAL MONTH or INTERVAL YEAR produces different values for each row (actually, with period of 4) when selecting data from table with more than one row.
> For example:
> {code}
> 0: jdbc:drill:zk=local> select cast('P314M' as interval month) from cp.`employee.json` limit 10;
> +--------------------------+
> | EXPR$0 |
> +--------------------------+
> | 26 years 2 months |
> | 81089877 years 5 months |
> | 1714858 years 8 months |
> | 6698 years 8 months |
> | 26 years 2 months |
> | 81089877 years 5 months |
> | 1714858 years 8 months |
> | 6698 years 8 months |
> | 26 years 2 months |
> | 81089877 years 5 months |
> +--------------------------+
> 10 rows selected (0.186 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)