ccccecccc opened a new issue, #18207: URL: https://github.com/apache/doris/issues/18207
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version Doris version 1.1.3-rc02-abceed6 ### What's Wrong? select count(*) from settle_record a join data_dm.data_gater b on concat(a.BRID,a.ZYID)=b.JZLSH where a.JGDM='123456'; 查询很慢。 去掉where a.JGDM='123456'后查询速度会提升很多。 explain该语句如下： `+----------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Explain String | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | PLAN FRAGMENT 0 | | OUTPUT EXPRS:<slot 4> count(*) | | PARTITION: UNPARTITIONED | | | | RESULT SINK | | | | 6:AGGREGATE (merge finalize) | | | output: count(<slot 4> count(*)) | | | group by: | | | cardinality=1 | | | | | 5:EXCHANGE | | | | PLAN FRAGMENT 1 | | | | PARTITION: HASH_PARTITIONED: `default_cluster:data_dm`.`data_gater`.`JZLSH` | | | | STREAM DATA SINK | | EXCHANGE ID: 05 | | UNPARTITIONED | | | | 3:AGGREGATE (update serialize) | | | output: count(*) | | | group by: | | | cardinality=1 | | | | | 2:CROSS JOIN | | | cross join: | | | predicates: `b`.`JZLSH` = concat(`a`.`BRID`, `a`.`ZYID`) | | | cardinality=101411109 | | | | | |----4:EXCHANGE | | | | | 1:OlapScanNode | | TABLE: data_gater(data_gater), PREAGGREGATION: OFF. Reason: __DORIS_DELETE_SIGN__ is used as conjuncts. aggExpr has more than one child | | PREDICATES: `b`.`__DORIS_DELETE_SIGN__` = 0 | | partitions=1/1, tablets=1/1, tabletList=73016051 | | cardinality=165101, avgRowSize=536.4761, numNodes=3 | | | | PLAN FRAGMENT 2 | | | | PARTITION: RANDOM | | | | STREAM DATA SINK | | EXCHANGE ID: 04 | | UNPARTITIONED | | | | 0:OlapScanNode | | TABLE: settle_record(settle_record), PREAGGREGATION: OFF. Reason: __DORIS_DELETE_SIGN__ is used as conjuncts. aggExpr has more than one child | | PREDICATES: `a`.`JGDM` = 123456, `a`.`__DORIS_DELETE_SIGN__` = 0 | | partitions=20/300, tablets=80/80, tabletList=70706766,70706770,70706774 ... | | cardinality=972946, avgRowSize=239.42343, numNodes=7 | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------+` ### What You Expected? 查询语句使用时间正常 ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] 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-unsubscr...@doris.apache.org.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
