CODEWITHSUNDEEP
cassandradatastaxcqldatastax-enterprisenosql
ubombi
ubombi

Reputation: 1174

Update existing rows, while altering Cassandra table

I have some table in Cassandra, and I need to add field with default data.

Is there way, to add default value to already existing rows, without updating all data manually?

 ALTER TABLE data ADD some_bool bool;  // Make it false for all existing records.

(Docs: ALTER TABLE Does not update existing rows)

Upvotes: 1

Views: 492

Answers (1)

xmas79
xmas79

Reputation: 5180

You have to take care of that at application level when you retrieve the rows. Cassandra will return data to the client as NULL, so everything depends on the driver and language you use. Check the driver's documentation to find out if the returned values are null or real values. They usually have an isNull method to perform such checks.

Upvotes: 2

Related Questions