You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jinfeng Ni (JIRA)" <ji...@apache.org> on 2015/05/26 23:37:03 UTC
[jira] [Commented] (DRILL-3004) Failure in planning join when
disabling hash join and exchanges
[ https://issues.apache.org/jira/browse/DRILL-3004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14559920#comment-14559920 ]
Jinfeng Ni commented on DRILL-3004:
-----------------------------------
[~amansinha100], could you please review the patch for DRILL-3004? Thanks!
> 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
>
> Attachments: 0001-DRILL-3004-Fix-CanNotPlan-in-physical-planning-when-.patch
>
>
> {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)