carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "kumar vishal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CARBONDATA-1278) Data Mismatch issue when dictionary column filter values doesn't exists in dictionary
Date Wed, 19 Jul 2017 18:39:00 GMT

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

kumar vishal commented on CARBONDATA-1278:
------------------------------------------

*Root cause*
when filter value is not present in dictionary, end key for that column  is updated with 0,and
hence btree jump is not selecting all the leaf node. 
*Fix*
To handle this issue end key should be updated with Integer max value, so that it can go till
last leafnode of btree

> Data Mismatch issue when dictionary column filter values doesn't exists in dictionary

> --------------------------------------------------------------------------------------
>
>                 Key: CARBONDATA-1278
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1278
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: kumar vishal
>            Assignee: kumar vishal
>
> Data Mismatch issue when dictionary column filter values doesn't exists in dictionary
when number of blocklet is more than 1 
> Select count(*) from table where column2='xxx' -- returning 100 rows.
> Select count(*) from table where column1='yyy' OR column2='xxx' -- returning 7 rows.
> Select count(*) from table where column1='yyy' is returning 0 rows 
> yyy does not exists in dictionary file.
> Query excepted value is 100 as yyy does not exists and its a or condition 



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message