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/08/07 07:24:15 UTC
[GitHub] [incubator-doris] HappenLee opened a new issue #4287: [Bug] EqjoinConjuncts column should have the same order like colocate distribute column
HappenLee opened a new issue #4287:
URL: https://github.com/apache/incubator-doris/issues/4287
**Describe the bug**
There is a table
```
CREATE TABLE `colo` (
`k1` tinyint(4) NULL COMMENT "",
`k2` smallint(6) NULL COMMENT "",
`k3` int(11) NULL COMMENT "",
`k4` bigint(20) SUM NULL COMMENT ""
) ENGINE=OLAP
AGGREGATE KEY(`k1`, `k2`, `k3`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`k1`, `k2`, `k3`) BUCKETS 5
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "DEFAULT"
);
```
```select b1.k1 from colo b1, colo b2 where b1.k1 = b2.k2 and b1.k2 = b2.k1 and b2.k3 = b1.k3;```
should not be colocate join, because the eqjoinConjuncts column do not have the same order like colocate distribute column.
The corret SQL should be
```select b1.k1 from colo b1, colo b2 where b1.k2 = b2.k2 and b1.k1 = b2.k1 and b2.k3 = b1.k3;```
----------------------------------------------------------------
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] HappenLee closed issue #4287: [Bug] EqjoinConjuncts column should have the same order like colocate distribute column
Posted by GitBox <gi...@apache.org>.
HappenLee closed issue #4287:
URL: https://github.com/apache/incubator-doris/issues/4287
----------------------------------------------------------------
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