You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Mujtaba Chohan (JIRA)" <ji...@apache.org> on 2017/01/11 23:28:16 UTC

[jira] [Created] (PHOENIX-3591) Group by is slower for immutable encoded table

Mujtaba Chohan created PHOENIX-3591:
---------------------------------------

             Summary: Group by is slower for immutable encoded table
                 Key: PHOENIX-3591
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3591
             Project: Phoenix
          Issue Type: Sub-task
            Reporter: Mujtaba Chohan


{noformat}
 select /*+ SERIAL NO_CACHE*/ c0,sum(k1) from $T group by c0
{noformat}

There are 100 distinct values in c0 column.

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)