[PHOENIX-4811] Phoenix Secondary Index isn't be used

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 4.13.1
• Labels: SecondaryIndex

Environment

Operating System : centos6.9 ;

Phoenix version : 4.13.1;

HBase version : 1.3.1;

• Flags: Important
• Assignee: Unassigned
• Reporter: MariaCarrie
• Created: 12/Jul/18 03:23
• Updated: 13/Jul/18 02:01
• Resolved: 12/Jul/18 04:58

Description

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';}