HappenLee opened a new issue #4230:
URL: https://github.com/apache/incubator-doris/issues/4230
**Is your feature request related to a problem? Please describe.**
Now the sql TPCDS 95：
```
with ws_wh as
(select ws1.ws_order_number,ws1.ws_warehouse_sk wh1,ws2.ws_warehouse_sk wh2
from web_sales ws1,web_sales ws2
where ws1.ws_order_number = ws2.ws_order_number
and ws1.ws_warehouse_sk <> ws2.ws_warehouse_sk)
```
web_sales join itself, but the Doris chose shuffle join. This is an
unreasonable choice， f left table and right table is same table, they are
naturally colocate relationship no need to check colocate group.
**Describe the solution you'd like**
ColocateJoin should support table join itself no need to check colocate
group.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
