phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mujtaba Chohan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-3590) Filter on value column for mutable encoded table is > 3X slower compared to non encoded table
Date Wed, 11 Jan 2017 23:23:16 GMT
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)

Mime
View raw message