[jira] [Commented] (DRILL-2936) TPCH 4 and 18 SF100 hangs when hash agg is turned off

["Ramana Inukonda Nagaraj (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14526984#comment-14526984 ] 

Ramana Inukonda Nagaraj commented on DRILL-2936:
------------------------------------------------

Narrowed it down to this. When the hashagg is turned off, the query hangs. Fragments are not reporting status and I do not see anything interesting in the logs.
When just hashjoin is turned off the query works fine. So it looks like the issue is in the streaming agg. 

> TPCH 4 and 18 SF100 hangs when hash agg is turned off
> -----------------------------------------------------
>
>                 Key: DRILL-2936
>                 URL: https://issues.apache.org/jira/browse/DRILL-2936
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>            Reporter: Ramana Inukonda Nagaraj
>            Assignee: Chris Westin
>            Priority: Critical
>         Attachments: Screen Shot 2015-05-01 at 2.40.36 PM.png
>
>
> sys options:
> {code}
> 0: jdbc:drill:schema=dfs.drillTestDirTpch100P> alter system set `planner.memory.max_query_memory_per_node` = 29205777612;
> 0: jdbc:drill:schema=dfs.drillTestDirTpch100P> alter system set `planner.enable_hashjoin`=false;
> 0: jdbc:drill:schema=dfs.drillTestDirTpch100P> alter system set `planner.enable_hashagg`=false;
> {code}
> On executing TPCH 04 query hangs. From the profiles page does not look like any fragments are making progress, the last progress time stamps were sometime back. 
> Attached is the logical plan. 



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