张延召 created PHOENIX-4811:
----------------------------
Summary: 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: 张延召
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)
