You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@carbondata.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/08/10 03:23:20 UTC

[jira] [Commented] (CARBONDATA-154) Block prune can not get the right blocks and query result is wrong

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

ASF GitHub Bot commented on CARBONDATA-154:
-------------------------------------------

GitHub user Zhangshunyu opened a pull request:

    https://github.com/apache/incubator-carbondata/pull/70

    [CARBONDATA-154] Fix the bug of block prune that query result is wrong.

    ## Why raise this pr:
    
    During block prune, endkey is always only decided by the last filter expression, this is a bug
    and can lead wrong result,
    For example, when load data whose dimension column is 120000 lines of 'a', 120000 lines of 'b', 120000 lines of 'c', if query like "select * from tablename where colname='c' or colname='b' or colname='a'" only 120000lines 'a' will be selected because of wrong endkey.
    
    ## How to solve this:
    
    Fix the end key consider all the filter expression end key get max and start key get (min - 1) for each column level, using this to produce a new start key an a new endkey.
    
    For more details please look at the test case.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/Zhangshunyu/incubator-carbondata blockprune

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-carbondata/pull/70.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #70
    
----
commit d2bdb538f8b30df39ae3730aa0498a44ed934f03
Author: Zhangshunyu <zh...@huawei.com>
Date:   2016-08-10T03:09:20Z

    fix the bug og block prune

----


> Block prune can not get the right blocks and query result is wrong
> ------------------------------------------------------------------
>
>                 Key: CARBONDATA-154
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-154
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: zhangshunyu
>            Priority: Critical
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)