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

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: SQL Parser

Environment

Drill 1.10

• Assignee: Unassigned
• Reporter: N Campbell
• Created: 30/Jun/17 12:22
• Updated: 30/Jun/17 12:22

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