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/08/24 03:01:16 UTC
[GitHub] [doris] cambyzju opened a new issue, #12024: [Bug] explain verbose with join display not correct
cambyzju opened a new issue, #12024:
URL: https://github.com/apache/doris/issues/12024
### 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
latest master
### What's Wrong?
explain verbose:
`explain verbose select col1, count(*) as num from table_A where entity_num in (select bc from table_B lateral view explode_bitmap(col2) tmp_v as bc) group by col1 order by num desc limit 10;`
The output is not as expected, `vec output tuple id` and `tuple ids` should not in the same line.
| 4:VAGGREGATE (update serialize) |
| | STREAMING |
| | output: count(*) |
| | group by: <slot 12> |
| | cardinality=-1 |
| | tuple ids: 4 |
| | |
| 3:VHASH JOIN |
| | join op: LEFT SEMI JOIN(BUCKET_SHUFFLE)[The src data has been redistributed] |
| | equal join conjunct: `entity_num` = `bc` |
| | runtime filters: RF000[in_or_bloom] <- `bc` |
| | cardinality=19999999 |
| | vec output tuple id: 6 **_| tuple ids: 0_** |
| | |
| |----6:VEXCHANGE |
| | tuple ids: 2
### What You Expected?
fix
### 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] [doris] cambyzju closed issue #12024: [Bug] explain verbose with join display not correct
Posted by GitBox <gi...@apache.org>.
cambyzju closed issue #12024: [Bug] explain verbose with join display not correct
URL: https://github.com/apache/doris/issues/12024
--
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