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

case expression using decimal expression causes Assignment conversion not possible

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.11.0
    • Fix Version/s: None
    • Component/s: Server
    • Labels:
      None
    • Environment:

      Drill 1.11 decimal type support enabled

      Description

      The error appears to be specific to an expression involving a decimal type within a case expression. If the math expressions are projected on their own the error is not thrown.

      Assignment conversion not possible from type "org.apache.drill.exec.expr.holders.NullableDecimal28SparseHolder" to type "org.apache.drill.exec.expr.holders.NullableDecimal38SparseHolder"

      select
      CASE when 'A' = 'A' THEN FIN_FINANCE_FACT.AMOUNT_MONTH * - 1 ELSE FIN_FINANCE_FACT.AMOUNT_MONTH * 1 END AS STMT_MONTH,
      CASE WHEN 'A' = 'A' THEN FIN_FINANCE_FACT.AMOUNT_YEAR_TO_DATE * - 1 ELSE FIN_FINANCE_FACT.AMOUNT_YEAR_TO_DATE * 1 END AS STMT_YEAR
      FROM dfs.gosalesdw1021p.FIN_FINANCE_FACT

        Attachments

        1. decimal_drill_exception.txt
          177 kB
          N Campbell
        2. parquet.tar.gz
          1.29 MB
          N Campbell

          Issue Links

            Activity

              People

              • Assignee:
                volodymyr Vova Vysotskyi
                Reporter:
                the6campbells N Campbell
              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: