[ https://issues.apache.org/jira/browse/PHOENIX-4632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16384084#comment-16384084 ]
James Taylor commented on PHOENIX-4632: --------------------------------------- [~rajeshbabu] - would you have any spare cycles to take a look? > Phoenix does not use local index if there is a field in where clause not > included in index > ------------------------------------------------------------------------------------------ > > Key: PHOENIX-4632 > URL: https://issues.apache.org/jira/browse/PHOENIX-4632 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.7.0 > Reporter: Alexey Karpov > Priority: Major > > HDP 2.6.2, Phoenix 4.7.0, HBase 1.1.2.2.6.2.0-205 > If in WHERE clause you have one field from the local index and one not from > the index, combined with AND operator, Phoenix decides to do a full scan. > Steps to reproduce: > CREATE TABLE test (id integer NOT NULL PRIMARY KEY, > name VARCHAR, description VARCHAR) > CREATE LOCAL INDEX ix_test_name ON test(name) > explain SELECT * FROM test WHERE name = 'a' AND description = 'b' > CLIENT 1-CHUNK PARALLEL 1-WAY ROUND ROBIN FULL SCAN OVER TEST > SERVER FILTER BY (NAME = 'a' AND DESCRIPTION = 'b') > After removing not indexed field in starts working as expected: > explain SELECT * FROM test WHERE name = 'a' > CLIENT 1-CHUNK PARALLEL 1-WAY ROUND ROBIN RANGE SCAN OVER TEST [1,'a'] > SERVER FILTER BY FIRST KEY ONLY > -- This message was sent by Atlassian JIRA (v7.6.3#76005)