yongjinhou opened a new issue, #31957: URL: https://github.com/apache/doris/issues/31957
### 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 2.0.4&2.0.5 ### What's Wrong? 1. 建库表 CREATE TABLE test_sys_materialized_view_2_test_add_key_column_in_mv_db.test_sys_materialized_view_2_test_add_key_column_in_mv_tb ( k0 BOOLEAN NOT NULL, k1 TINYINT NOT NULL, k2 SMALLINT NOT NULL, k3 INT NOT NULL, k4 BIGINT NOT NULL, k5 LARGEINT NOT NULL, k6 DECIMALV3(9, 3) NOT NULL, k7 CHAR(5) NOT NULL, k8 DATE NOT NULL, k9 DATETIME NOT NULL, k10 VARCHAR(20) NOT NULL, k11 DOUBLE NOT NULL, k12 FLOAT NOT NULL ) PARTITION BY RANGE(k1) ( PARTITION p1 VALUES LESS THAN ("-10"), PARTITION p2 VALUES LESS THAN ("0"), PARTITION p3 VALUES LESS THAN ("10"), PARTITION p4 VALUES LESS THAN ("20") ) DISTRIBUTED BY HASH(k4, k5) BUCKETS 10 2. 创建物化视图 CREATE MATERIALIZED VIEW sa0f7_aterialized_view_2_test_add_key_column_in_mv_index AS SELECT k0, max(k8), min(k11), sum(k12), count(k10), hll_union(hll_hash(k7)), bitmap_union(to_bitmap(k2)) from test_sys_materialized_view_2_test_add_key_column_in_mv_db.test_sys_materialized_view_2_test_add_key_column_in_mv_tb group by k0 3. 查询物化视图创建结果 SHOW ALTER TABLE ROLLUP FROM test_sys_materialized_view_2_test_add_key_column_in_mv_db WHERE TableName = "test_sys_materialized_view_2_test_add_key_column_in_mv_tb" 4. 导入数据（这里可以自己生成数据，通过其他方式导入） LOAD LABEL test_sys_materialized_view_2_test_add_key_column_in_mv_db.label_20_16_44_10_279851_1918864334 ( DATA INFILE("afs://ip:port/user/palo/data/qe/baseall.txt") INTO TABLE `test_sys_materialized_view_2_test_add_key_column_in_mv_tb` (`v1`, `v2`, `v3`, `v4`, `v6`, `v7`, `v8`, `v9`, `v10`, `v11`, `v12`) SET(k1=v1, k2=abs(v2), k3=v3, k4=v4, k6=v6, k7=v7, k8=v8, k9=v9, k10=v10, k11=v11, k12=v12, k0=v7, k5=v4*101)) WITH BROKER "ahdfs" ( "username" = "palo", "password" = "3trqDWfl") PROPERTIES( "max_filter_ratio"="0.5" )' 5.查询 EXPLAIN SELECT k0, max(k8), min(k11), sum(k12), count(k10), hll_union(hll_hash(k7)), bitmap_union(to_bitmap(k2)) from test_sys_materialized_view_2_test_add_key_column_in_mv_db.test_sys_materialized_view_2_test_add_key_column_in_mv_tb group by k0 查询没有命中物化视图 ### 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
