I have table with many millions rows. I added new field, and this is null in old rows, so I need to update it to 0, can I do it?)
I have table with many millions rows. I added new field, and this is null in old rows, so I need to update it to 0, can I do it?)
Yes you can do it. You can update the value of new column. For this you can write a utility which will scan the complete table and update record one by one. If you are aware with spark and use it then things will be easier and faster.