[DRILL-3943] CannotPlanException caused by ExpressionReductionRule

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0
• Component/s: Query Planning & Optimization
• Assignee: Jason Altekruse
• Reporter: Sean Hsuan-Yi Chu
• Created: 16/Oct/15 07:13
• Updated: 17/Nov/15 16:47
• Resolved: 16/Oct/15 22:06

Description

For a query such as:

SELECT count(DISTINCT employee_id) as col1,
count((to_number(date_diff(now(), cast(birth_date AS date)),'####'))) as col2
FROM cp.`employee.json`

cannot plan exception will be thrown because ExpressionReductionRule does not properly simply the call "now()".

This issue is similar to DRILL-2808, but that one focuses on error message.

Issue Links

• is related to: DRILL-2808 Substr function throws weird message when wrong arguments are passed in