[ https://issues.apache.org/jira/browse/PHOENIX-5116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lars Hofhansl reassigned PHOENIX-5116: -------------------------------------- Resolution: Fixed Assignee: Lars Hofhansl Thanks [~vincentpoon]. This is (hopefully) the last fix missing in making uncovered local indexes generally applicable to all query plan selection. > DistinctPrefixFilterIT fails. > ----------------------------- > > Key: PHOENIX-5116 > URL: https://issues.apache.org/jira/browse/PHOENIX-5116 > Project: Phoenix > Issue Type: Task > Affects Versions: 4.15.0 > Reporter: Lars Hofhansl > Assignee: Lars Hofhansl > Priority: Major > Fix For: 4.15.0 > > Attachments: 5116-master.txt, 5116-master.txt, 5116.txt > > > Caused by this scenario outlined on PHOENIX-5109: > {quote} > This just does not end. Now there's a special case for the following: > * compound key of VARCHAR > * SELECT DISTINCT <prefix of the key> > * Salting is enabled > * There is a local index on an unrelated column > Now Phoenix selects a full local index scan, which is heuristically less > efficient... I think. > The problem is that there are cases where a plan for a salted table > nonetheless gets a key range that is not salted - does not have the salt > range in it. That throws the logic off in this case. > {quote} -- This message was sent by Atlassian JIRA (v7.6.3#76005)