[DRILL-4918] Adding 2 dates results in AssertionError: Multiple functions with best cost found

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Execution - Data Types, Functions - Drill
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 29/Sep/16 21:01
• Updated: 03/Oct/16 09:30

Description

git.commit.id.abbrev=2295715

The below query fails

select l_commitdate+l_receiptdate from cp.`tpch/lineitem.parquet`;
Error: SYSTEM ERROR: AssertionError: Multiple functions with best cost found

Fragment 0:0

[Error Id: 983983bd-73e3-45c8-a377-e7022a5899c7 on qa-node182.qa.lab:31010] (state=,code=0)

The more likely scenario is that this operation is not supported. Atleast we should throw a proper error message. I attached the error from the logs