张延召 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)