We are not able to alter column of datatype decimal to text in apache cassandra 3.11.11 version.Below are the details with the trace of error.
We use below command to alter column
step 1:-Where mycol data type was of data type 'text'.
Step 2:-alter table mytable drop mycol ;
Step 3:-alter table mytable add mycol decimal;
InvalidRequest: Error from server: code=2200 [Invalid query] message="Cannot re-add previously dropped column 'mycol' of type decimal, incompatible with previous type text".
We were able to perform this before on apache cassandra 3.11.3 version but since we have upgraded to apache cassandra 3.11.11 we are facing the above issue while alteration.