You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/01/31 16:14:34 UTC
[jira] [Commented] (DRILL-2068) Disable Implicit Cross Join with
Condition on the same table (e.g., select ... from a, b where a._1 = a._2)
[ https://issues.apache.org/jira/browse/DRILL-2068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14299859#comment-14299859 ]
Sean Hsuan-Yi Chu commented on DRILL-2068:
------------------------------------------
This is also a cross-join, which is solved in DRILL-1921.
> Disable Implicit Cross Join with Condition on the same table (e.g., select ... from a, b where a._1 = a._2)
> -------------------------------------------------------------------------------------------------------------
>
> Key: DRILL-2068
> URL: https://issues.apache.org/jira/browse/DRILL-2068
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Sean Hsuan-Yi Chu
> Assignee: Sean Hsuan-Yi Chu
>
> Although explicit cross join is temporarily disabled,
> we can attain the identical purpose by
> select *
> from cp.`tpch/nation.parquet` a,
> cp.`tpch/region.parquet` b
> where a.... = a....;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)