[
https://issues.apache.org/jira/browse/DRILL-5858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
N Campbell updated DRILL-5858:
------------------------------
Attachment: parquet.tar.gz
create or replace view dfs.gosalesdw1021p.FIN_FINANCE_FACT as select cast (
SUBMISSION_KEY as integer) as `SUBMISSION_KEY`,cast ( ORGANIZATION_KEY as
integer) as `ORGANIZATION_KEY`,cast ( ACCOUNT_KEY as integer) as
`ACCOUNT_KEY`,cast ( MONTH_KEY as integer) as `MONTH_KEY`,cast (
AMOUNT_YEAR_TO_DATE as decimal (19,2)) as `AMOUNT_YEAR_TO_DATE`,cast (
AMOUNT_MONTH as decimal (19,2)) as `AMOUNT_MONTH` from
dfs.gosalesdw1021p.`/data/fin_finance_fact`;
> 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
> 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
(v6.4.14#64029)
