> Fixed bug for fetching the error value of decimal type in presto
> ----------------------------------------------------------------
>
> Key: CARBONDATA-1392
> URL:
https://issues.apache.org/jira/browse/CARBONDATA-1392> Project: CarbonData
> Issue Type: Bug
> Components: presto-integration
> Affects Versions: 1.1.1
> Reporter: steven-qin
> Assignee: steven-qin
> Priority: Minor
> Labels: patch
> Fix For: 1.2.0
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> h1. The following is based on TPCH test.
> h2. create statement:
> {code:java}
> create table lineitem (l_orderkey int ,l_partkey int ,l_suppkey int ,l_linenumber int ,l_quantity decimal(15,2) ,l_extendedprice decimal(15,2) ,l_discount decimal(15,2) ,l_tax decimal(15,2) ,l_returnflag string ,l_linestatus string ,l_shipdate date ,l_commitdate date ,l_receiptdate date ,l_shipinstruct string ,l_shipmode string ,l_comment string ) stored by 'carbondata'
> {code}
> h2. query sql:
> {code:java}
> select l_quantity,l_extendedprice,l_discount,l_tax from lineitem where l_orderkey=15413986 and l_linenumber=7;
> {code}
> h2. The below is correct in spark:
> l_quantity | l_extendedprice | l_discount | l_tax
> 11.00 | 16549.17 | 0.07 | 0.04
> h2. The below is wrong in presto:
> l_quantity | l_extendedprice | l_discount | l_tax
> 0.11 | 165.49 | 0.00 | 0.00
Locked
