drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xiao Meng (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-814) Support cast interval format with negative zero
Date Thu, 22 May 2014 18:01:06 GMT
Xiao Meng created DRILL-814:
-------------------------------

             Summary: 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


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.2#6252)

Mime
View raw message