Nitin Kashyap created CARBONDATA-3883:
-----------------------------------------
Summary: 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
Attachments: image-2020-06-30-20-20-53-267.png, image-2020-06-30-20-21-06-026.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.
{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)
Locked
