Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.10.0
-
None
-
None
-
Drill 1.10
Description
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