phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 张延召 (JIRA) <j...@apache.org>
Subject [jira] [Created] (PHOENIX-4811) Phoenix Secondary Index isn't be used
Date Thu, 12 Jul 2018 03:24:00 GMT
张延召 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)

Mime
View raw message