[jira] [Commented] (PHOENIX-4632) Phoenix does not use local index if there is a field in where clause not included in index

["James Taylor (JIRA)" <ji...@apache.org>]

    [ 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)