[jira] [Created] (PHOENIX-3590) Filter on value column for mutable encoded table is > 3X slower compared to non encoded table

[Mujtaba Chohan (JIRA)]

Mujtaba Chohan created PHOENIX-3590:
---------------------------------------

             Summary: Filter on value column for mutable encoded table is > 3X 
slower compared to non encoded table
                 Key: PHOENIX-3590
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3590
             Project: Phoenix
          Issue Type: Sub-task
            Reporter: Mujtaba Chohan
            Assignee: Samarth Jain


{noformat}
select /*+ SERIAL NO_CACHE*/ k2,c0,c1000,c2000,c3000 from $T where c4000='50' 
limit 1
{noformat}

Query get progressively slower if the column which is filtered is the last 
column of the table.

For data and schema see data generator script in 
https://issues.apache.org/jira/browse/PHOENIX-3560



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