为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
Colocate Join不生效一个表和一个异步物化视图
【背景】做过哪些操作？3.1.2
【业务影响】
【是否存算分离】
【StarRocks版本】例如：1.18.2
【集群规模】例如：3fe（1 follower+2observer）+5be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
±---------------------------------------------------------------------------------------------+
| Explain String |
±---------------------------------------------------------------------------------------------+
| PLAN FRAGMENT 0 |
| OUTPUT EXPRS:1: imp_date | 2: contentid | 3: mediaid | 149: sum |
| PARTITION: UNPARTITIONED |
| |
| RESULT SINK |
| |
| 9:EXCHANGE |
| limit: 1 |
| |
| PLAN FRAGMENT 1 |
| OUTPUT EXPRS: |
| PARTITION: HASH_PARTITIONED: 1: imp_date, 2: contentid, 3: mediaid |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 09 |
| UNPARTITIONED |
| |
| 8:AGGREGATE (merge finalize) |
| | output: sum(149: sum) |
| | group by: 1: imp_date, 2: contentid, 3: mediaid |
| | limit: 1 |
| | |
| 7:EXCHANGE |
| |
| PLAN FRAGMENT 2 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 07 |
| HASH_PARTITIONED: 1: imp_date, 2: contentid, 3: mediaid |
| |
| 6:AGGREGATE (update serialize) |
| | STREAMING |
| | output: sum(148: fad_ratio) |
| | group by: 1: imp_date, 2: contentid, 3: mediaid |
| | |
| 5:Project |
| | <slot 1> : 1: imp_date |
| | <slot 2> : 2: contentid |
| | <slot 3> : 3: mediaid |
| | <slot 148> : 148: fad_ratio |
| | |
| 4:HASH JOIN |
| | join op: INNER JOIN (BUCKET_SHUFFLE) |
| | colocate: false, reason: |
| | equal join conjunct: 144: imp_date = 1: imp_date |
| | equal join conjunct: 145: contentid = 2: contentid |
| | equal join conjunct: 146: mediaid = 3: mediaid |
| | equal join conjunct: 147: uuid = 4: uuid |
| | |
| |----3:EXCHANGE |
| | |
| 0:OlapScanNode |
| TABLE: view_tmp_income_article_flow_wide_news_di_colocate_join |
| PREAGGREGATION: ON |
| PREDICATES: 145: contentid IS NOT NULL, 146: mediaid IS NOT NULL, 147: uuid IS NOT NULL |
| partitions=1/52 |
| rollup: view_tmp_income_article_flow_wide_news_di_colocate_join |
| tabletRatio=8/8 |
| tabletList=641309,641310,641311,641312,641313,641314,641315,641316 |
| cardinality=18087765 |
| avgRowSize=52.17997 |
| numNodes=0 |
| |
| PLAN FRAGMENT 3 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 03 |
| BUCKET_SHUFFLE_HASH_PARTITIONED: 1: imp_date, 2: contentid, 3: mediaid, 4: uuid |
| |
| 2:Project |
| | <slot 1> : 150: imp_date |
| | <slot 2> : 151: contentid |
| | <slot 3> : 152: mediaid |
| | <slot 4> : 153: uuid |
| | |
| 1:OlapScanNode |
| TABLE: view_tmp_income_article_flow_wide_news_di_colocate_join |
| PREAGGREGATION: ON |
| partitions=1/52 |
| rollup: view_tmp_income_article_flow_wide_news_di_colocate_join |
| tabletRatio=8/8 |
| tabletList=641309,641310,641311,641312,641313,641314,641315,641316 |
| cardinality=18087765 |
| avgRowSize=88.35994 |
| numNodes=0 |
±---------------------------------------------------------------------------------------------+
