hf200012 opened a new issue #7592: URL: https://github.com/apache/incubator-doris/issues/7592
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version 0.15 ### What's Wrong? 1060 - errCode = 2, detailMessage = Duplicate column name 'account', Time: 0.169000s ### What You Expected? -- dwd 表 ``` CREATE TABLE dwd_recharge1 ( `day` date, g VARCHAR(32) NOT NULL , p VARCHAR(32) NOT NULL , account VARCHAR(32) NOT NULL , order_id VARCHAR(50) NOT NULL , s INT NOT NULL , money DECIMAL(19,4) NOT NULL, level int , product_id VARCHAR(32) NOT NULL , product_num VARCHAR(32) NOT NULL , reason VARCHAR(20) , time DATETIME , is_success boolean NOT NULL ) ENGINE=olap DUPLICATE KEY(day,g,p,account) PARTITION BY RANGE(day) ( PARTITION P_20210926 VALUES [('2021-09-26'), ('2021-09-27')), PARTITION P_20210927 VALUES [('2021-09-27'), ('2021-09-28')) ) DISTRIBUTED BY HASH(account) BUCKETS 16 PROPERTIES( "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.end" = "3", "dynamic_partition.prefix" = "p", "dynamic_partition.buckets" = "16", "replication_num" = "1", "colocate_with" = "aGroup"); ``` Create materialized view statement： ``` create materialized view dwd_recharge_dgp_3 as select day,p,g,account, sum(money) money,count(distinct account) num from dwd_recharge1 a group by 1,2,3,4 ``` Creation failed ``` create materialized view dwd_recharge_dgp as select day, sum(money) money from dwd_recharge2 a group by day ``` Creation success ### 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]
