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/09/01 07:39:31 UTC
[GitHub] [incubator-doris] HappenLee opened a new issue #4496: [Bug] Join hint lose efficacy when the table is in colocate group.
HappenLee opened a new issue #4496:
URL: https://github.com/apache/incubator-doris/issues/4496
**Describe the bug**
There is a table baseall, hash by `k1`.
The baseall join itself, it should be `colocate join`. But sometime we need other join way, so we can use join hint,
but the colocate join can **lose efficacy of join hint**
```
desc select * from baseall a join [shuffle] baseall b on a.k1 = b.k1;
```
it should be shuffle join, but it still be colocate join.
```
| 2:HASH JOIN |
| | join op: INNER JOIN |
| | hash predicates: |
| | colocate: true |
| | equal join conjunct: `a`.`k1` = `b`.`k1`
```
**Expected behavior**
The user should have the power to chose join way by hoin hint
```
2:HASH JOIN |
| | join op: INNER JOIN (PARTITIONED) |
| | hash predicates: |
| | colocate: false, reason: Has join hint |
| | equal join conjunct: `a`.`k1` = `b`.`k1` |
| |
```
----------------------------------------------------------------
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] morningman closed issue #4496: [Bug] Join hint lose efficacy when the table is in colocate group.
Posted by GitBox <gi...@apache.org>.
morningman closed issue #4496:
URL: https://github.com/apache/incubator-doris/issues/4496
----------------------------------------------------------------
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