[jira] [Created] (DRILL-5638) Increase the precision of INTERVAL types to be larger than 2

[N Campbell (JIRA)]

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)