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

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

    [ https://issues.apache.org/jira/browse/PHOENIX-4811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16542415#comment-16542415 ] 

张延召 commented on PHOENIX-4811:
------------------------------

I tried this,and it did,but I have a question,why can I not create this index with (name, age)  in mysql database,What is the mechanism that led me to do this in phoenix?

> 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: 张延召
>            Priority: Major
>              Labels: SecondaryIndex
>   Original Estimate: 48h
>  Remaining Estimate: 48h
>
> 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)