[ https://issues.apache.org/jira/browse/CARBONDATA-3883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ajantha Bhat resolved CARBONDATA-3883. -------------------------------------- Fix Version/s: 2.1.0 Resolution: Fixed > Table result shows invalid data for local diction column In Presto > ------------------------------------------------------------------ > > Key: CARBONDATA-3883 > URL: https://issues.apache.org/jira/browse/CARBONDATA-3883 > Project: CarbonData > Issue Type: Bug > Components: presto-integration > Affects Versions: 2.0.0 > Reporter: Nitin Kashyap > Priority: Minor > Labels: newbie > Fix For: 2.1.0 > > Attachments: image-2020-06-30-20-20-53-267.png, > image-2020-06-30-20-21-06-026.png > > Original Estimate: 2h > Remaining Estimate: 2h > > Record value for string fields is inaccurate when read from presto for table > with local dictionary is enabled; > > *Step 1:* Create a table with local dictionary enabled with string column. > {code:sql} > CREATE TABLE testorders18(orderkey bigint, orderstatus varchar(7), totalprice > double, orderdate date) STORED BY 'org.apache.carbondata.format' ;{code} > *Step 2:* Insert records, and delete such a way that a delete delta is > created (i.e. segment still has some records present) > {code:sql} > INSERT INTO testorders18 VALUES (11,'FAILURE', 125.15, DATE'2019-05-17'), > (12,'SUCCESS', 135.12, DATE'2019-05-20'),(13,'1FAILURE', 125.15, > DATE'2019-05-17'), (14,'SUCCESS', 135.12, DATE'2019-05-20'); > DELETE FROM testorders18 WHERE orderkey IN (SELECT orderkey FROM testorders18 > WHERE orderstatus= 'FAILURE'); > {code} > !image-2020-06-30-20-20-53-267.png! > *Step 3:* Read the result in presto with pushdown row filter enabled > {code:bash} > -Dcarbon.push.rowfilters.for.vector=true{code} > {code:sql} > select * from testorders18;{code} > !image-2020-06-30-20-21-06-026.png! > > -- This message was sent by Atlassian Jira (v8.3.4#803005)