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 2022/06/16 05:18:32 UTC
[GitHub] [incubator-doris] starocean999 opened a new issue, #10182: [Bug] intersect operator takes an unexpected long time to execute in some scenario
starocean999 opened a new issue, #10182:
URL: https://github.com/apache/incubator-doris/issues/10182
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
master
### What's Wrong?
use tpch 1G data, and run the following sql:
select count(*) from ( select l1.l_linenumber, l1.l_shipdate, l1.l_comment from lineitem l1 order by l_orderkey limit 100000 intersect
select l2.l_linenumber, l2.l_comment, l2.l_shipdate from lineitem l2 order by l_orderkey limit 100000 intersect
select l3.l_linenumber, l3.l_comment, l3.l_shipdate from lineitem l3 order by l_orderkey limit 100000 ) tmp;
| count(*) |
| ---- |
| 0 |
1 row in set (10.46 sec)
### What You Expected?
should take much less time like bellow:
| count(*) |
| ---- |
| 0 |
1 row in set (0.36 sec)
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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.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] yiguolei closed issue #10182: [Bug] intersect operator takes an unexpected long time to execute in some scenario
Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #10182: [Bug] intersect operator takes an unexpected long time to execute in some scenario
URL: https://github.com/apache/incubator-doris/issues/10182
--
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