Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

lg3877482_193831 avatar image
lg3877482_193831 asked ·

How can I update the value of timestamp column for 1M rows?

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.

cql
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

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!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.