[jira] [Commented] (CARBONDATA-3883) Table result shows invalid data for local diction column In Presto

2020-06-30 Thread Nitin Kashyap (Jira)


[ 
https://issues.apache.org/jira/browse/CARBONDATA-3883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17148770#comment-17148770
 ] 

Nitin Kashyap commented on CARBONDATA-3883:
---

Added PR with fix

[https://github.com/apache/carbondata/pull/3818]

> 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
> 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)


[jira] [Created] (CARBONDATA-3883) Table result shows invalid data for local diction column In Presto

2020-06-30 Thread Nitin Kashyap (Jira)
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)