Sean Hsuan-Yi Chu created DRILL-3943: ----------------------------------------
Summary: CannotPlanException caused by ExpressionReduction rule Key: DRILL-3943 URL: https://issues.apache.org/jira/browse/DRILL-3943 Project: Apache Drill Issue Type: Bug Components: Query Planning & Optimization Reporter: Sean Hsuan-Yi Chu Assignee: Sean Hsuan-Yi Chu Fix For: 1.3.0 For a query such as: {code} SELECT count(DISTINCT employee_id) as col1, count((to_number(date_diff(now(), cast(birth_date AS date)),'####'))) as col2 FROM cp.`employee.json` {code} 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)