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:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to