[
https://issues.apache.org/jira/browse/DRILL-1182?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-1182:
----------------------------------
Assignee: Mehant Baid
> Decimal has an issue when used in case statement where the else expression
> contains a literal
> ---------------------------------------------------------------------------------------------
>
> Key: DRILL-1182
> URL: https://issues.apache.org/jira/browse/DRILL-1182
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Reporter: Rahul Challapalli
> Assignee: Mehant Baid
> Fix For: 0.4.0
>
> Attachments: error.log, lineitem.tbl
>
>
> git.commit.id.abbrev=e5c2da0
> The below query fails with an Assertion Error:
> select
> case
> when l_linestatus = 'Success' then l_extendedprice
> else 0
> end
> from lineitem;
> The source 'lineitem' is a view on top of a txt file. While creating the view
> when we change the type of l_extendedprice from decimal to double, this issue
> goes away. Below is the original view definition:
> create view lineitem as select cast(columns[0] as int) l_orderkey,
> cast(columns[1] as int) l_partkey, cast(columns[2] as int) l_suppkey,
> cast(columns[3] as int) l_linenumber, cast(columns[4] as decimal) l_quantity,
> cast(columns[5] as decimal) l_extendedprice, cast(columns[6] as decimal)
> l_discount, cast(columns[7] as decimal) l_tax, columns[8] l_returnflag,
> columns[9] l_linestatus, cast(columns[10] as date) l_shipdate,
> cast(columns[11] as date) l_commitdate, cast(columns[12] as date)
> l_receiptdate, columns[13] l_shipinstruct, columns[14] l_shipmode,
> columns[15] l_comment from `lineitem.tbl`;
> I also attached the log file along with the source data. Let me know if you
> have any questions
--
This message was sent by Atlassian JIRA
(v6.2#6252)
