steven-qin created CARBONDATA-1392:
--------------------------------------
Summary: 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
Priority: Minor
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
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
