Mailing-List: contact issues-help@carbondata.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@carbondata.apache.org
Date: Fri, 22 Dec 2017 06:14:00 +0000 (UTC)
From: "Liang Chen (JIRA)" <jira@apache.org>
To: issues@carbondata.apache.org
Message-ID: <JIRA.13126241.1513764625000.517206.1513923240233@Atlassian.JIRA>
In-Reply-To: <JIRA.13126241.1513764625000@Atlassian.JIRA>
References: <JIRA.13126241.1513764625000@Atlassian.JIRA> <JIRA.13126241.1513764625628@jira-lw-us.apache.org>
Subject: [jira] [Resolved] (CARBONDATA-1920) Sparksql query result is not
 same as presto on same sql
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Fri, 22 Dec 2017 06:14:05 -0000


     [ https://issues.apache.org/jira/browse/CARBONDATA-1920?page=3Dcom.atl=
assian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Liang Chen resolved CARBONDATA-1920.
------------------------------------
       Resolution: Fixed
    Fix Version/s: 1.3.0

> Sparksql query result is not same as presto on same sql=20
> --------------------------------------------------------
>
>                 Key: CARBONDATA-1920
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-192=
0
>             Project: CarbonData
>          Issue Type: Bug
>          Components: presto-integration
>    Affects Versions: 1.3.0
>         Environment: spark2.1,presto 0.187
>            Reporter: anubhav tarar
>            Assignee: anubhav tarar
>             Fix For: 1.3.0
>
>          Time Spent: 1h 10m
>  Remaining Estimate: 0h
>
> i  use carbondata version is 1.2.0 and spark version is 1.6.0.
>      in my test case
>    1.Creating a Table
>   cc.sql("create table IF NOT EXISTS  test.table5(id string,name
> String,city String,age int) stored by 'carbondata' *
> tblproperties('DICTIONARY_INCLUDE' =3D 'age')* ")
>   2.load csv data into table,data like this:
>     id,name,city,age
>     1,david,shenzhen,31
>     88,eason,shenzhen,27
>     3,jarry,wuhan,35
>    3.select from sparksql,result is :
>   +-----+--------+-----------+------+--+
> | id  |  name  |   city    | age  |
> +-----+--------+-----------+------+--+
> | 1   | david  | shenzhen  | 31   |
> | 3   | jarry  | wuhan     | 35   |
> | 88  | eason  | shenzhen  | 27   |
> +-----+--------+-----------+------+--+
>    this result is correct
>  4.select from presto,result is:
>  id | name  |   city   | age
> ----+-------+----------+-----
>  1  | david | shenzhen |   3
>  3  | jarry | wuhan    |   4
>  88 | eason | shenzhen |   2
> (3 rows)
>   look at the age filed,is wrong
> I know why this happens because I used dictionary encoding in the age fie=
ld=E3=80=82


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)