didasai opened a new issue, #27292: URL: https://github.com/apache/doris/issues/27292
### 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.2 ### What's Wrong? 表结构如下： ``` CREATE TABLE `report_dsp_date_user3` ( `m_date` date NOT NULL, `dsp_id` char(20) NOT NULL DEFAULT "", `uvrate` double REPLACE_IF_NOT_NULL NULL DEFAULT "0" COMMENT '', `uvrate_bid` double REPLACE_IF_NOT_NULL NULL DEFAULT "0" COMMENT '', `uv_showsuc` bigint(20) REPLACE_IF_NOT_NULL NULL DEFAULT "0" COMMENT '', `uv_click` bigint(20) REPLACE_IF_NOT_NULL NULL DEFAULT "0" COMMENT '', `crdate` datetime MIN NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=OLAP AGGREGATE KEY(`m_date`, `dsp_id`) COMMENT '' PARTITION BY RANGE(`m_date`) (PARTITION p20231108 VALUES [('2023-11-08'), ('2023-11-09')), PARTITION p20231109 VALUES [('2023-11-09'), ('2023-11-10')), PARTITION p20231110 VALUES [('2023-11-10'), ('2023-11-11')), PARTITION p20231111 VALUES [('2023-11-11'), ('2023-11-12')), PARTITION p20231112 VALUES [('2023-11-12'), ('2023-11-13')), PARTITION p20231113 VALUES [('2023-11-13'), ('2023-11-14')), PARTITION p20231114 VALUES [('2023-11-14'), ('2023-11-15')), PARTITION p20231115 VALUES [('2023-11-15'), ('2023-11-16')), PARTITION p20231116 VALUES [('2023-11-16'), ('2023-11-17')), PARTITION p20231117 VALUES [('2023-11-17'), ('2023-11-18')), PARTITION p20231118 VALUES [('2023-11-18'), ('2023-11-19')), PARTITION p20231119 VALUES [('2023-11-19'), ('2023-11-20')), PARTITION p20231120 VALUES [('2023-11-20'), ('2023-11-21')), PARTITION p20231121 VALUES [('2023-11-21'), ('2023-11-22')), PARTITION p20231122 VALUES [('2023-11-22'), ('2023-11-23')), PARTITION p20231123 VALUES [('2023-11-23'), ('2023-11-24'))) DISTRIBUTED BY HASH(`dsp_id`) BUCKETS 10 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "is_being_synced" = "false", "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.time_zone" = "Asia/Shanghai", "dynamic_partition.start" = "-2147483648", "dynamic_partition.end" = "3", "dynamic_partition.prefix" = "p", "dynamic_partition.replication_allocation" = "tag.location.default: 3", "dynamic_partition.buckets" = "32", "dynamic_partition.create_history_partition" = "false", "dynamic_partition.history_partition_num" = "-1", "dynamic_partition.hot_partition_num" = "0", "dynamic_partition.reserved_history_periods" = "NULL", "dynamic_partition.storage_policy" = "", "dynamic_partition.storage_medium" = "HDD", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false" ); ``` 执行sql如下： ``` insert into report_dsp_date_user3(m_date,dsp_id,uvrate) values ('2023-11-20','wscs',1); insert into report_dsp_date_user3(m_date,dsp_id,uvrate_bid) values ('2023-11-20','wscs',2); ``` 执行后的结果如下： ``` m_date dsp_id uvrate uvrate_bid uv_showsuc uv_click crdate 2023-11-20 wscs 0 2 0 0 2023-11-20 18:12:17 ``` 问题说明： ``` 没有实现部分列更新，在尝试修改默认值为null时，发现可以了，希望可以不设置默认值为null实现部分列更新 ``` ### What You Expected? 希望执行后的结果如下： ``` m_date dsp_id uvrate uvrate_bid uv_showsuc uv_click crdate 2023-11-20 wscs 1 2 0 0 2023-11-20 18:12:17 ``` ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] 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]
