You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2017/06/30 12:23:00 UTC
[jira] [Created] (DRILL-5638) Increase the precision of INTERVAL
types to be larger than 2
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)