carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From manishgupta88 <...@git.apache.org>
Subject [GitHub] carbondata pull request #952: [CARBONDATA-1094] Wrong results returned by th...
Date Thu, 25 May 2017 13:29:43 GMT
GitHub user manishgupta88 opened a pull request:

    https://github.com/apache/carbondata/pull/952

    [CARBONDATA-1094] Wrong results returned by the query in case inverted index is not created
on a column

    Problem: Wrong results returned by the query in case inverted index is not created on
a column
    
    Fix: When inverted index does not exist for a column or column is not a sort column then
    1. Block or blocklet cannot be pruned as data for that column is not sorted
    2. While applying the filter linear search should be applied instead of binary search
as binary search can be applied only on sorted data
    
    Verified result
    ------------------
    SELECT * FROM index1 WHERE city >= 'Shanghai'
    +---+-----+----------+
    | id| name|      city|
    +---+-----+----------+
    | 11|James|Washington|
    | 20|Kevin| Singapore|
    |  9| Mary|     Tokyo|
    | 16| Paul|  Shanghai|
    |  4| Sara|     Tokyo|
    +---+-----+----------+

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

    $ git pull https://github.com/manishgupta88/incubator-carbondata inverted_index_filter_issue_fix

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

    https://github.com/apache/carbondata/pull/952.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 #952
    
----
commit 87d7bb2bd74569905f5c24e9cb91735df8ac27da
Author: manishgupta88 <tomanishgupta18@gmail.com>
Date:   2017-05-25T13:14:30Z

    Problem: Wrong results returned by the query in case inverted index is not created on
a column
    
    Fix: When inverted index does not exist for a column or column is not a sort column then
    1. Block or blocklet cannot be pruned as data for that column is not sorted
    2. While applying the filter linear search should be applied instead of binary search
as binary search can be applied only on sorted data

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

Mime
View raw message