Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
1.11.0
-
None
-
None
-
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
Attachments
Issue Links
- relates to
-
DRILL-6094 Decimal data type enhancements
- Closed