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] [Created] (PHOENIX-3987) Do not read index when Select All in case of index scan.
Date Mon, 03 Jul 2017 02:25:00 GMT
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)

Mime
View raw message