[jira] [Created] (PHOENIX-4811) Phoenix Secondary Index isn't be used

["张延召 (JIRA)" <ji...@apache.org>]

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