you can try below command for updating existing array data If you want to overwrite existing value with new value for the array column, you can use below update statement update test1 set dept=array('marketing', 'FINANCE') where name='a'; If you want to append new value, then you can use below update statement. update test1 set dept=split(concat_ws(',',dept,'FINANCE'),',') where name ='a';
... View more
