jelly Chen created PHOENIX-1387:
-----------------------------------

             Summary: Local index is not use when the query like "select * from 
dataTable where c1 like 'abc%'".
                 Key: PHOENIX-1387
                 URL: https://issues.apache.org/jira/browse/PHOENIX-1387
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.1
         Environment: jdk1.6 linux
            Reporter: jelly Chen


According to the official doc:  "Local indexes can be used even when the query 
isn't fully covered i.e. Phoenix automatically retrieve the columns not in the 
index through point gets against the data table."

But the index did not be used when i executed query statement like "select * 
from dataTable where c1 like 'abc%'". 
Certainly 'c1' is indexed in local index.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to