You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2015/05/09 16:18:59 UTC

[jira] [Created] (DRILL-3004) Failure in planning join when disabling hash join and exchanges

Jacques Nadeau created DRILL-3004:
-------------------------------------

             Summary: Failure in planning join when disabling hash join and exchanges
                 Key: DRILL-3004
                 URL: https://issues.apache.org/jira/browse/DRILL-3004
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
            Reporter: Jacques Nadeau
            Assignee: Jinfeng Ni
             Fix For: 1.1.0


{code}
ALTER SESSION SET `planner.enable_hashjoin` = false";
{code}

{code}
ALTER SESSION SET `planner.disable_exchanges` = true";
{code}

{code}
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
{code}




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