[jira] [Resolved] (PHOENIX-372) Why I do a group by operation cost very long time

["Gabriel Reid (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gabriel Reid resolved PHOENIX-372.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.

> Why I do a group by operation cost very long time
> -------------------------------------------------
>
>                 Key: PHOENIX-372
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-372
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: netease-datastream
>
> I hava installed the phoenix and do a simple test.
> A very simple table has four columns: userid,butterid,filtertype,time
> I have import 80G data into this table.
> I run the sql 
> select userId,sum(filtertype) from test group by userid
> It cost more than two minutes and the squirrel has throw timeout exception.
> I see you performance test is very quickly.
> But this test is too slow.
> I wonder if there is my config fault or others.



--
This message was sent by Atlassian JIRA
(v6.2#6252)