[PHOENIX-1387] Local index is not use when the query like "select * from dataTable where c1 like 'abc%'".

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.1.0
• Fix Version/s: 4.2.1

Environment

jdk1.6 linux

• Assignee: rajeshbabu
• Reporter: jelly Chen
• Created: 28/Oct/14 06:41
• Updated: 21/Nov/15 02:17
• Resolved: 31/Oct/14 06:54

Description

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.