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