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 2021/08/29 14:27:17 UTC
[GitHub] [incubator-doris] qzsee opened a new issue #6525: [BUG] Join query result is unstable when the predicate is pushed down to exchange node
qzsee opened a new issue #6525:
URL: https://github.com/apache/incubator-doris/issues/6525
**Describe the bug**
DDL
```sql
create table A(a1 bigint,a2 bigint)
ENGINE=OLAP
DISTRIBUTED BY HASH(a1) BUCKETS 1
PROPERTIES (
"replication_num" = "1"
);
insert into A values(1,1),
(2,2),
(3,3),
(4,4),
(5,5);
create table B(b1 bigint,b2 bigint)
ENGINE=OLAP
DISTRIBUTED BY HASH(b1) BUCKETS 1
PROPERTIES (
"replication_num" = "1"
);
insert into B values(2,1),
(3,2),
(4,3),
(5,4);
create table C(c1 bigint)
ENGINE=OLAP
DISTRIBUTED BY HASH(c1) BUCKETS 1
PROPERTIES (
"replication_num" = "1"
);
insert into C values(1),
(2),
(3),
(4);
```
Join query
```sql
select
t1.a1,
t2.b2,
sum(t1.a2)
from A t1
left join (
select b1,b2 from B
) t2
on t1.a1=t2.b1
join (
select c1 from C
) t3
on t2.b2 = t3.c1
group by
t1.a1,
t2.b2
```
Execute the SQL multiple times
Result1
```sql
+------+------+----------------+
| a1 | b2 | sum(`t1`.`a2`) |
+------+------+----------------+
| 3 | 2 | 3 |
| 2 | 1 | 2 |
| 4 | 3 | 4 |
+------+------+----------------+
```
Result2
```sql
+------+------+----------------+
| a1 | b2 | sum(`t1`.`a2`) |
+------+------+----------------+
| 3 | 2 | 3 |
| 2 | 1 | 2 |
| 4 | 3 | 4 |
| 5 | 4 | 5 |
+------+------+----------------+
```
--
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: commits-unsubscribe@doris.apache.org
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 commented on issue #6525: [BUG] Join query result is unstable when the predicate is pushed down to exchange node
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #6525:
URL: https://github.com/apache/incubator-doris/issues/6525#issuecomment-909941736
新版本的 runtime filter 取消了这部分逻辑了。所以新版本没问题。
旧版本的 runtime filter 确实有可能有你这个问题。
--
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: commits-unsubscribe@doris.apache.org
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] qzsee commented on issue #6525: [BUG] Join query result is unstable when the predicate is pushed down to exchange node
Posted by GitBox <gi...@apache.org>.
qzsee commented on issue #6525:
URL: https://github.com/apache/incubator-doris/issues/6525#issuecomment-910067507
> 新版本的 runtime filter 取消了这部分逻辑了。所以新版本没问题。
> 旧版本的 runtime filter 确实有可能有你这个问题。
是的，但是新版本的runtime filter，也有IN类型的过滤，这部分同样有复制谓词的过程，如果_tuple_idx不清空，不太清楚有些特别的查询是否继续命中这种bug。
--
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: commits-unsubscribe@doris.apache.org
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] qzsee commented on issue #6525: [BUG] Join query result is unstable when the predicate is pushed down to exchange node
Posted by GitBox <gi...@apache.org>.
qzsee commented on issue #6525:
URL: https://github.com/apache/incubator-doris/issues/6525#issuecomment-910067507
> 新版本的 runtime filter 取消了这部分逻辑了。所以新版本没问题。
> 旧版本的 runtime filter 确实有可能有你这个问题。
是的，但是新版本的runtime filter，也有IN类型的过滤，这部分同样有复制谓词的过程，如果_tuple_idx不清空，不太清楚有些特别的查询是否继续命中这种bug。
--
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: commits-unsubscribe@doris.apache.org
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] qzsee closed issue #6525: [BUG] Join query result is unstable when the predicate is pushed down to exchange node
Posted by GitBox <gi...@apache.org>.
qzsee closed issue #6525:
URL: https://github.com/apache/incubator-doris/issues/6525
--
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: commits-unsubscribe@doris.apache.org
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 commented on issue #6525: [BUG] Join query result is unstable when the predicate is pushed down to exchange node
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #6525:
URL: https://github.com/apache/incubator-doris/issues/6525#issuecomment-909941736
新版本的 runtime filter 取消了这部分逻辑了。所以新版本没问题。
旧版本的 runtime filter 确实有可能有你这个问题。
--
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: commits-unsubscribe@doris.apache.org
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