JeongMin Ju created PHOENIX-3987:
------------------------------------
Summary: 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
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)
