You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/07/31 11:30:20 UTC
[GitHub] [incubator-doris] HappenLee opened a new issue #4230: ColocateJoin should support table join itself no need to check colocate group
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] EmmyMiao87 closed issue #4230: ColocateJoin should support table join itself no need to check colocate group
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 closed issue #4230:
URL: https://github.com/apache/incubator-doris/issues/4230
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org