[DRILL-3004] Failure in planning join when disabling hash join and exchanges

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: Query Planning & Optimization
• Assignee: Jinfeng Ni
• Reporter: Jacques Nadeau
• Created: 09/May/15 14:18
• Updated: 27/May/15 22:23
• Resolved: 27/May/15 22:23

Description

ALTER SESSION SET `planner.enable_hashjoin` = false";

ALTER SESSION SET `planner.disable_exchanges` = true";

SELECT
  nations.N_NAME,
regions.R_NAME
FROM
cp.`tpch/nation.parquet` nations
JOIN
cp.`tpch/region.parquet` regions
on nations.N_REGIONKEY = regions.R_REGIONKEY where 1 = 0