[DRILL-5637] Date arith using literals SYSTEM ERROR: AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: Server

Environment

Drill 1.10

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

Description

Use any file with one row in it.

Submit the following statement to Drill which is performing interval arith on a date using literals.

select DATE '2000-01-29' + INTERVAL -'1' YEAR from dfs.certp.TVERSION

Error: SYSTEM ERROR: AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes:
validated type:
RecordType(TIMESTAMP(0) NOT NULL EXPR$0) NOT NULL
converted type:
RecordType(DATE NOT NULL EXPR$0) NOT NULL
rel:
LogicalProject(EXPR$0=[DATETIME_PLUS(2000-01-29, -12)])
LogicalTableScan(table=[[dfs, certp, TVERSION]])