N Campbell created DRILL-5858: --------------------------------- Summary: case expression using decimal expression causes Assignment conversion not possible Key: DRILL-5858 URL: https://issues.apache.org/jira/browse/DRILL-5858 Project: Apache Drill Issue Type: Bug Components: Server Affects Versions: 1.11.0 Environment: Drill 1.11 decimal type support enabled Reporter: N Campbell
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 -- This message was sent by Atlassian JIRA (v6.4.14#64029)