Nitin Kashyap created CARBONDATA-3883:

             Summary: Table result shows invalid data for local diction column 
In Presto
                 Key: CARBONDATA-3883
             Project: CarbonData
          Issue Type: Bug
          Components: presto-integration
    Affects Versions: 2.0.0
            Reporter: Nitin Kashyap
         Attachments: image-2020-06-30-20-20-53-267.png, 

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.
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)
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');

*Step 3:* Read the result in presto with pushdown row filter enabled
select * from testorders18;{code}



This message was sent by Atlassian Jira

Reply via email to