[GitHub] [incubator-doris] blackfox1983 opened a new issue #3847: support modifying aggregation type of column from replace to replace_if_not_null

[GitBox <gi...@apache.org>]

blackfox1983 opened a new issue #3847:
URL: https://github.com/apache/incubator-doris/issues/3847


   **Is your feature request related to a problem? Please describe.**
   The current version cannot support modifying the aggregation type of columns from REPLACE to REPLACE_IF_NOT_NULL.
   ```
   alter table mytbl MODIFY column pv BIGINT REPLACE_IF_NOT_NULL NULL;
   ERROR 1064 (HY000): errCode = 2, detailMessage = Can not change aggregation type
   ```
   
   This operation is very common because there are too many restrictions with replace, the original data will be overwritten with a value of NULL  if there is any mistake.
   So for us, the use cost is relatively high.
   
   **Describe the solution you'd like**
   support modifying a column from replace to replace_if_not_null, or from replace_if_not_null to replace
   
   **Describe alternatives you've considered**
   A clear and concise description of any alternative solutions or features you've considered.
   
   


----------------------------------------------------------------
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org