[
https://issues.apache.org/jira/browse/PHOENIX-5096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17002172#comment-17002172
]
Lars Hofhansl edited comment on PHOENIX-5096 at 12/23/19 10:40 AM:
-------------------------------------------------------------------
Thinking about this again. It should be possible to limit the regions of the
index scan to only the regions that the the DataPlan indicates... Somewhere in
BaseResultIterators.getParallelScans(...)
was (Author: lhofhansl):
Thinking about this again. It should be possible to limit the regions of the
index scan to only the regions that the the DataPlan indicates.
> Local index region pruning is not working as expected.
> ------------------------------------------------------
>
> Key: PHOENIX-5096
> URL: https://issues.apache.org/jira/browse/PHOENIX-5096
> Project: Phoenix
> Issue Type: Bug
> Reporter: Lars Hofhansl
> Priority: Major
>
> The pruning of local indexes should do the following:
> * Use the local index
> * Reduce the number of regions based on filters on the table's primary key
> (i.e. WHERE conditions including prefixes of the primary key)
> Instead it looks like in order for this to work the needed PK column need to
> be included in the local index itself, changing the sort order of the local
> index.
> I'll provide some examples in the comments.
> [~giacomotaylor], [~tdsilva], [~vincentpoon], [~elserj], [~gjacoby]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
