kangkaisen commented on issue #242: Poor query performance under high concurrence URL: https://github.com/apache/incubator-doris/issues/242#issuecomment-429760191 @imay Hi, which isn't the cause. I have added the predicate inference improvement in my banch. The sql3 explain is below: ``` +------------------------------------------------------------+ | Explain String | +------------------------------------------------------------+ | PLAN FRAGMENT 0 | | OUTPUT EXPRS:<slot 4> | | | PARTITION: UNPARTITIONED | | | | RESULT SINK | | | | 7:AGGREGATE (merge finalize) | | | output: count(<slot 4>) | | | group by: | | | tuple ids: 2 | | | | | 6:EXCHANGE | | tuple ids: 2 | | | | PLAN FRAGMENT 1 | | OUTPUT EXPRS: | | PARTITION: HASH_PARTITIONED: `t1`.`dt`, `t1`.`wm_poi_id` | | | | STREAM DATA SINK | | EXCHANGE ID: 06 | | UNPARTITIONED | | | | 3:AGGREGATE (update serialize) | | | output: count(*) | | | group by: | | | tuple ids: 2 | | | | | 2:HASH JOIN | | | join op: LEFT OUTER JOIN (PARTITIONED) | | | hash predicates: | | | `t1`.`dt` = `t6`.`dt` | | | `t1`.`wm_poi_id` = `t6`.`wm_poi_id` | | | tuple ids: 0 1N | | | | | |----5:EXCHANGE | | | tuple ids: 1 | | | | | 4:EXCHANGE | | tuple ids: 0 | | | | PLAN FRAGMENT 2 | | OUTPUT EXPRS: | | PARTITION: RANDOM | | | | STREAM DATA SINK | | EXCHANGE ID: 05 | | HASH_PARTITIONED: `t6`.`dt`, `t6`.`wm_poi_id` | | | | 1:OlapScanNode | | TABLE: B | | PREAGGREGATION: OFF | | PREDICATES: `t6`.`dt` = 20180909 | | partitions=1/11 | | rollup: topic_poi_list_merge_d | | buckets=20/20 | | cardinality=5824575 | | avgRowSize=33.136944 | | tuple ids: 1 | | | | PLAN FRAGMENT 3 | | OUTPUT EXPRS: | | PARTITION: RANDOM | | | | STREAM DATA SINK | | EXCHANGE ID: 04 | | HASH_PARTITIONED: `t1`.`dt`, `t1`.`wm_poi_id` | | | | 0:OlapScanNode | | TABLE: A | | PREAGGREGATION: OFF | | PREDICATES: `t1`.`dt` = 20180909 | | partitions=1/11 | | rollup: aggr_poi_info_dd | | buckets=20/20 | | cardinality=5777107 | | avgRowSize=201.1324 | | tuple ids: 0 | ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
