[
https://issues.apache.org/jira/browse/PHOENIX-4811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thomas D'Silva resolved PHOENIX-4811.
-------------------------------------
Resolution: Not A Problem
The index stores data sorted on the indexed columns. If your query filters on
name and age and you want to use the index create the index with (name, age) or
(age, name)
> Phoenix Secondary Index isn't be used
> -------------------------------------
>
> Key: PHOENIX-4811
> URL: https://issues.apache.org/jira/browse/PHOENIX-4811
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.13.1
> Environment: Operating System : centos6.9 ;
> Phoenix version : 4.13.1;
> HBase version : 1.3.1;
> Reporter: 张延召
> Priority: Major
> Labels: SecondaryIndex
> Original Estimate: 48h
> Remaining Estimate: 48h
>
> I created two indexes (not Covered Indexes):
> ^create table test(id varchar not null primary key,name varchar,age varchar
> ,sex varchar);^
> ^create local index if not exists val_test_name on test(name);^
> ^create local index if not exists val_test_age on test(age);^
> ^upsert into test(id,name,age,sex)values('myid','name','age','sex');^
> It is work to use one index:
> ^explain select name from test where name = 'name';^
> But why can't hit index when using multiple indexes？
> ^explain select name,age from test where name = 'name' and age = 'age';^
>
>
>
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
