Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.10.0
-
None
-
None
-
Drill 1.10
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]])