Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3943

CannotPlanException caused by ExpressionReductionRule

    XMLWordPrintableJSON

Details

    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.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2808 Substr function throws weird message when wrong arguments are passed in

          • Major - Major loss of function.
          • Open

          Activity

            People

              jaltekruse Jason Altekruse
              seanhychu Sean Hsuan-Yi Chu
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: