You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2015/11/10 19:37:10 UTC
[jira] [Updated] (DRILL-814) Support cast interval format with
negative zero
[ https://issues.apache.org/jira/browse/DRILL-814?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krystal updated DRILL-814:
--------------------------
Labels: interval (was: )
> Support cast interval format with negative zero
> -----------------------------------------------
>
> Key: DRILL-814
> URL: https://issues.apache.org/jira/browse/DRILL-814
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Xiao Meng
> Priority: Minor
> Labels: interval
> Fix For: Future
>
>
> Drill cannot identify negative sign before 0 in interval data format.
> For example,
> *Query 1*
> {code}
> select cast(cast('P-0DT1H0M0S' as VARCHAR(32)) as interval second) from cp.`employee.json` limit 1;
> {code}
> returns
> {code}
> +------------+
> | EXPR$0 |
> +------------+
> | PT3600S |
> +------------+
> {code}
> *Query 2*
> {code}
> select cast(cast('PT-1H0M0S' as VARCHAR(32)) as interval second) from cp.`employee.json` limit 1;
> {code}
> returns
> {code}
> +------------+
> | EXPR$0 |
> +------------+
> | PT-3600S |
> +------------+
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)