[jira] [Created] (DRILL-2936) TPCH 4 SF100 hangs when hash agg and join are turned off

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

Ramana Inukonda Nagaraj created DRILL-2936:
----------------------------------------------

             Summary: TPCH 4 SF100 hangs when hash agg and join are 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)