How can I update the value of the date to date + 3years from CQL? If not through CQL, then how, I have around 1M rows.
You won't be able to do it via CQL.
One way to do it is with Spark where you need to write an app that would scan through your data and update the values. Cheers!
5 People are following this question.
