asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Taewoo Kim (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ASTERIXDB-920) Wrong results for a primary index with composite keys
Date Tue, 12 Apr 2016 20:46:25 GMT

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

Taewoo Kim commented on ASTERIXDB-920:
--------------------------------------

One way is implementing a filter during an index search as Mike suggested somewhere else.
:-)

Suppose we have two int fields A and B and a composite index on (A,B). 

If a query predicate is "A > 10 and B > 5", then the optimizer will pick this composite
index and a Hyracks job will be created to traverse the index using "A > 10". During this
search, after the search cursor fetches each tuple that satisfies "A > 10", it can apply
"B > 5" condition on the fly since it can see A and B at the same time. Then, we don't
need to apply an additional SELECT operator to filter out false positives. 

> Wrong results for a primary index with composite keys
> -----------------------------------------------------
>
>                 Key: ASTERIXDB-920
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-920
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: AsterixDB, Storage
>            Reporter: asterixdb-importer
>            Assignee: Ildar Absalyamov
>         Attachments: fbm.adm
>
>
> Wrong results for a primary index with composite keys



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

Mime
View raw message