[jira] [Created] (PHOENIX-3332) Secondary Indexes being ignored even with hints when addressing dynamic columns

["Eric Yang (JIRA)" <ji...@apache.org>]

Eric Yang created PHOENIX-3332:
----------------------------------

             Summary: Secondary Indexes being ignored even with hints when addressing dynamic columns
                 Key: PHOENIX-3332
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3332
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.6.0
            Reporter: Eric Yang
            Priority: Minor


I have the following index built

create local index “indexonCol1" on "table ("col1");

##index is used as expected
select * from "table" where "col1" = 'Value1'; 

##index is not used as expected

select * from "table"("dynamicColumn" varchar) where "col1" = 'Value1';

even using a hint

select /*+ index("table" "indexonCol1") */ * from "table"("dynamicColumn" varchar) where "col1"='Value1'

it still uses a full table scan rather than an index. I would have expected that the secondary Index would have been used in the secondary query as well given that the underlying table and conditions are the same





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