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

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Pending Closed
• Fix Version/s: 1.0.0
• Component/s: Execution - Flow
• Assignee: Jacques Nadeau
• Reporter: Ramana Inukonda Nagaraj
• Created: 01/May/15 21:43
• Updated: 14/May/15 02:31
• Resolved: 14/May/15 02:31

Description

sys options:

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;

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.