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