carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "steven-qin (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CARBONDATA-1392) Fixed bug for fetching the error value of decimal type in presto
Date Fri, 18 Aug 2017 06:35:00 GMT

     [ https://issues.apache.org/jira/browse/CARBONDATA-1392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

steven-qin updated CARBONDATA-1392:
-----------------------------------
    Description: 
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

  was:
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


> 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
>              Labels: patch
>
> 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)

Mime
View raw message