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/25 20:59:34 UTC

[jira] [Updated] (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:all-tabpanel ]

Sean Hsuan-Yi Chu updated DRILL-2068:
-------------------------------------
    Description: 
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....; 

  was:
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....; 

That is, join on 


> 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)