Thanks Dylan, We are looking into the problem. Regards Bhavya
On Fri, Dec 1, 2017 at 2:25 PM, dylan <[email protected]> wrote: > hello all: > i am 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' = '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 > field。 > > Can anyone help me with this problem? > > > > > > > -- > Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556. > n5.nabble.com/ >
