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