tangbinyeer opened a new issue, #24293: URL: https://github.com/apache/doris/issues/24293
### 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 1.2.4.1 ### What's Wrong? BASE table: ```text CREATE TABLE IF NOT EXISTS address_token_balance ( `address` VARCHAR(44) NOT NULL COMMENT "地址", `token` VARCHAR(44) NOT NULL COMMENT "交易代币", `balance` STRING COMMENT "余额", `balance_en` TINYINT NOT NULL DEFAULT "0" COMMENT "余额数量级，10^n", `update_time` BIGINT NOT NULL COMMENT "更新时间戳" ) ENGINE=OLAP UNIQUE KEY(`address`, `token`) COMMENT "地址余额表" DISTRIBUTED BY HASH(`address`, `token`) BUCKETS AUTO PROPERTIES ( "replication_num" = "1", "bloom_filter_columns"= "token", "enable_unique_key_merge_on_write" = "true" ); ``` Want to create a materialized view for sorting balances，sql: ```text CREATE MATERIALIZED VIEW address_token_blance_order_mv AS SELECT balance_en, balance, address, token from address_token_balance ORDER BY balance_en desc, balance desc; ``` got an error message： ```text Execution failed: Error Failed to execute sql: java.sql.SQLException: (conn=59) errCode = 2, detailMessage = MergeOnWrite table can't create materialized view. ``` ### What You Expected? Am I using it wrong or is it a bug? ### How to Reproduce? Follow the steps above ### 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]
