drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5638) Increase the precision of INTERVAL types to be larger than 2
Date Fri, 30 Jun 2017 12:23:00 GMT
N Campbell created DRILL-5638:
---------------------------------

             Summary: Increase the precision of INTERVAL types to be larger than 2
                 Key: DRILL-5638
                 URL: https://issues.apache.org/jira/browse/DRILL-5638
             Project: Apache Drill
          Issue Type: Improvement
          Components: SQL Parser
    Affects Versions: 1.10.0
         Environment: Drill 1.10
            Reporter: N Campbell


You cannot express an interval literal (DAY, HOUR, MINUTE, SECOND, ...) with a precision greater
than 2.

select INTERVAL '100' DAY from dfs.certp.TVERSION
Error: VALIDATION ERROR: From line 1, column 8 to line 1, column 25: Interval field value
100 exceeds precision of DAY(2) field


select INTERVAL '160' HOUR from dfs.certp.TVERSION
Error: VALIDATION ERROR: From line 1, column 8 to line 1, column 26: Interval field value
160 exceeds precision of HOUR(2) field





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

Mime
View raw message