phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lars Hofhansl (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-5096) Local index region pruning is not working as expected.
Date Fri, 11 Jan 2019 04:47:00 GMT

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

Lars Hofhansl commented on PHOENIX-5096:
----------------------------------------

I suppose the thought was that the index just needs to be declared with the prefix queries
in mind.

Not what I expected, since with local indexes we can do better, but it's not wrong or anything.

I had though we declare a local index as before and _in addition_ prune the regions, purely
based on the pk parts of the WHERE clause.


> 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
(v7.6.3#76005)

Mime
View raw message