drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sean Hsuan-Yi Chu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2068) Disable Implicit Cross Join with Condition on the same table (e.g., select ... from a, b where a._1 = a._2)
Date Sun, 25 Jan 2015 19:55:34 GMT
Sean Hsuan-Yi Chu created DRILL-2068:
----------------------------------------

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

That is, join on 



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

Mime
View raw message