EmmyMiao87 opened a new issue #3016: The pre aggregation is ON in new selector when result of query only has key columns URL: https://github.com/apache/incubator-doris/issues/3016 **Describe the bug** The pre aggregation is difference between old and new selector when result of query only has key columns. The query is select k1 from aggregate_table; The pre aggregation is ON in this query. mysql> explain select k1 from test_deduplicate_agg; +-----------------------------------+ | Explain String | +-----------------------------------+ | PLAN FRAGMENT 0 | | OUTPUT EXPRS:`k1` | | PARTITION: UNPARTITIONED | | | | RESULT SINK | | | | 1:EXCHANGE | | tuple ids: 0 | | | | PLAN FRAGMENT 1 | | OUTPUT EXPRS: | | PARTITION: RANDOM | | | | STREAM DATA SINK | | EXCHANGE ID: 01 | | UNPARTITIONED | | | | 0:OlapScanNode | | TABLE: test_deduplicate_agg | | PREAGGREGATION: ON | | partitions=1/1 | | rollup: only_key | | tabletRatio=3/3 | | tabletList=15042,15044,15046 | | cardinality=0 | | avgRowSize=0.0 | | numNodes=0 | | tuple ids: 0 | +-----------------------------------+ 28 rows in set (0.08 sec) While the correct answer is OFF. **To Reproduce** Steps to reproduce the behavior: 1. create table ``` CREATE TABLE `test_deduplicate_agg` ( `k1` int(11) NULL COMMENT "", `k2` int(11) NULL COMMENT "", `v1` bigint(20) SUM NULL COMMENT "", `v2` bigint(20) SUM NULL COMMENT "" ) ENGINE=OLAP AGGREGATE KEY(`k1`, `k2`) COMMENT "OLAP" DISTRIBUTED BY HASH(`k1`) BUCKETS 3 PROPERTIES ( "storage_type" = "COLUMN", "replication_num" = "1", "in_memory" = "false" ); ``` 2. query `select k1 from test_deduplicate_agg;` 3. explain query on new selector ``` mysql> explain select k1 from test_deduplicate_agg; +-----------------------------------+ | Explain String | +-----------------------------------+ | PLAN FRAGMENT 0 | | OUTPUT EXPRS:`k1` | | PARTITION: UNPARTITIONED | | | | RESULT SINK | | | | 1:EXCHANGE | | tuple ids: 0 | | | | PLAN FRAGMENT 1 | | OUTPUT EXPRS: | | PARTITION: RANDOM | | | | STREAM DATA SINK | | EXCHANGE ID: 01 | | UNPARTITIONED | | | | 0:OlapScanNode | | TABLE: test_deduplicate_agg | | PREAGGREGATION: ON | | partitions=1/1 | | rollup: only_key | | tabletRatio=3/3 | | tabletList=15042,15044,15046 | | cardinality=0 | | avgRowSize=0.0 | | numNodes=0 | | tuple ids: 0 | +-----------------------------------+ 28 rows in set (0.08 sec) ``` **Expected behavior** The correct pre aggregation value is OFF ``` mysql> explain select k1 from test_deduplicate_agg;; +----------------------------------------------------+ | Explain String | +----------------------------------------------------+ | PLAN FRAGMENT 0 | | OUTPUT EXPRS:`k1` | | PARTITION: UNPARTITIONED | | | | RESULT SINK | | | | 1:EXCHANGE | | tuple ids: 0 | | | | PLAN FRAGMENT 1 | | OUTPUT EXPRS: | | PARTITION: RANDOM | | | | STREAM DATA SINK | | EXCHANGE ID: 01 | | UNPARTITIONED | | | | 0:OlapScanNode | | TABLE: test_deduplicate_agg | | PREAGGREGATION: OFF. Reason: No AggregateInfo | | partitions=1/1 | | rollup: only_key | | tabletRatio=3/3 | | tabletList=15042,15044,15046 | | cardinality=2 | | avgRowSize=408.5 | | numNodes=1 | | tuple ids: 0 | +----------------------------------------------------+ 28 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. 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]
