Re: [I] apache drill failed to execute SQL such as ' table1 left join table2 on condition 1 or condition 2' (drill)

[via GitHub]

fengqiyuqingpingzhimo commented on issue #2781:
URL: https://github.com/apache/drill/issues/2781#issuecomment-1484423994

   > I'm not sure what you're trying to do with this query, but I found that 
rewriting it like this worked:
   > 
   > ```sql
   >  SELECT aa.employee_id 
   >  FROM cp.`employee.json` aa , 
   >  cp.`employee.json` bb
   >  WHERE aa.employee_id=bb.employee_id or aa.employee_id=bb.position_id
   > ```
   Thank you very much for your answer,But when I switched to MySQL, I 
encountered another problem,I created two storage configurations that point to 
the same MySQL,There is no problem when I use the same storage, such as SQL:
   ```sql
    select * from bb.eladmin.table1 a, bb.eladmin.table2 b where a.id =b.id or 
a.name=b.name
   ```
   However, when I use two storage systems, the sql is as follows:
   ```sql
    select * from bb.eladmin.table1 a, zz.eladmin.table2 b where a.id =b.id or 
a.name=b.name
   ```
   It still reports errors，Let me set the option 
'planner.enable_nljoin_for_scalar_only' to false and try again，This is why？
   
![aaa](https://user-images.githubusercontent.com/26477240/227832563-0ea63c84-3357-4959-beca-64af91ef9a66.png)
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org