[ https://issues.apache.org/jira/browse/DRILL-5858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Volodymyr Vysotskyi resolved DRILL-5858. ---------------------------------------- Resolution: Fixed Fixed in the scope of DRILL-6094 > 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 > Assignee: Volodymyr Vysotskyi > Priority: Major > Attachments: decimal_drill_exception.txt, parquet.tar.gz > > > 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 (v7.6.3#76005)