Accelarator commented on issue #14101: URL: https://github.com/apache/doris/issues/14101#issuecomment-1308278154
> 麻烦发下join sql的explain
``` SQL
+---------------------------------------------------------------------------------------------+
| Explain String
|
+---------------------------------------------------------------------------------------------+
| PLAN FRAGMENT 0
|
| OUTPUT EXPRS:<slot 17> | <slot 18> | <slot 21>
|
| PARTITION: UNPARTITIONED
|
|
|
| VRESULT SINK
|
|
|
| 10:VEXCHANGE
|
| limit: 10
|
|
|
| PLAN FRAGMENT 1
|
|
|
| PARTITION: HASH_PARTITIONED: <slot 3> `appid`, <slot 4> `uid`
|
|
|
| STREAM DATA SINK
|
| EXCHANGE ID: 10
|
| UNPARTITIONED
|
|
|
| 4:VHASH JOIN
|
| | join op: LEFT OUTER JOIN(BROADCAST)[The src data has been
redistributed] |
| | equal join conjunct: <slot 4> `uid` = <slot 12> `uid`
|
| | equal join conjunct: <slot 3> `appid` = <slot 11> `appid`
|
| | cardinality=-1
|
| | vec output tuple id: 6 | output slot ids: 17 18 21
|
| | limit: 10
|
| |
|
| |----9:VEXCHANGE
|
| |
|
| 6:VAGGREGATE (merge finalize)
|
| | group by: <slot 3> `appid`, <slot 4> `uid`
|
| | cardinality=-1
|
| |
|
| 5:VEXCHANGE
|
|
|
| PLAN FRAGMENT 2
|
|
|
| PARTITION: HASH_PARTITIONED: <slot 11> `appid`, <slot 12> `uid`
|
|
|
| STREAM DATA SINK
|
| EXCHANGE ID: 09
|
| UNPARTITIONED
|
|
|
| 8:VAGGREGATE (merge finalize)
|
| | output: max(<slot 13> max(`province`))
|
| | group by: <slot 11> `appid`, <slot 12> `uid`
|
| | cardinality=-1
|
| |
|
| 7:VEXCHANGE
|
|
|
| PLAN FRAGMENT 3
|
|
|
| PARTITION: RANDOM
|
|
|
| STREAM DATA SINK
|
| EXCHANGE ID: 07
|
| HASH_PARTITIONED: <slot 11> `appid`, <slot 12> `uid`
|
|
|
| 3:VAGGREGATE (update serialize)
|
| | STREAMING
|
| | output: max(`province`)
|
| | group by: `appid`, `uid`
|
| | cardinality=-1
|
| |
|
| 2:VOlapScanNode
|
| TABLE: app_online_duration_detail(app_online_duration_detail),
PREAGGREGATION: ON |
| PREDICATES: `totaldate` >= '2022-11-02 00:00:00', `totaldate` <=
'2022-11-03 00:00:00' |
| partitions=2/12, tablets=64/64, tabletList=14027,14029,14031 ...
|
| cardinality=1314663899, avgRowSize=623.6309, numNodes=3
|
|
|
| PLAN FRAGMENT 4
|
|
|
| PARTITION: RANDOM
|
|
|
| STREAM DATA SINK
|
| EXCHANGE ID: 05
|
| HASH_PARTITIONED: <slot 3> `appid`, <slot 4> `uid`
|
|
|
| 1:VAGGREGATE (update serialize)
|
| | STREAMING
|
| | group by: `appid`, `uid`
|
| | cardinality=-1
|
| |
|
| 0:VOlapScanNode
|
| TABLE: app_online_duration_detail(app_online_duration_detail),
PREAGGREGATION: ON |
| PREDICATES: `totaldate` >= '2022-11-02 00:00:00', `totaldate` <=
'2022-11-03 00:00:00' |
| partitions=2/12, tablets=64/64, tabletList=14027,14029,14031 ...
|
| cardinality=1314663899, avgRowSize=623.6309, numNodes=3
|
+---------------------------------------------------------------------------------------------+
86 rows in set (0.02 sec)
```
--
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-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
