phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "JeongMin Ju (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-3987) Do not read index when Select All in case of index scan.
Date Mon, 03 Jul 2017 02:33:00 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-3987?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

JeongMin Ju updated PHOENIX-3987:
---------------------------------
    Attachment: PHOENIX-3987.patch

> Do not read index when Select All in case of index scan.
> --------------------------------------------------------
>
>                 Key: PHOENIX-3987
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3987
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.10.0
>            Reporter: JeongMin Ju
>            Priority: Minor
>         Attachments: PHOENIX-3987.patch
>
>
> I created table and local index, and then request select * query on index column.
> {noformat}
> create table test (
> rowkey not null primary key,
> column1 varchar,
> column2 varchar
> )
> salt_buckets=10
> ;
> create local index idx_test_column1 on test(column1);
> select * from test where column1 = 'xxxxxxx';
> {noformat}
> It is obvious that this query needs to scan the index.
> However, the query plan is a full scan.
> This is because the query rewrite for the Projected Table refers to the "Salt" column.
> For this reason, it should skip the salt column when rewriting the query.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message