CASSANDRA CQL3 : Set value to entire column

database cassandra cql cql3 cqlsh
Quentin DESBOIS picture Quentin DESBOIS · Aug 5, 2015 · Viewed 8.9k times · Source

For my Cassandra Database, I need to set a value in column for all rows in my table.

I see in SQL, we can do : 

UPDATE table SET column1= XXX;

but in CQL (in cqlsh), It doesn't work ! I don't want to update row by row until 9500 rows.

Do you have any suggestion ?

Thank you :)

Answer

hamid147 picture hamid147 · Dec 28, 2015

You can use update query with IN clause instead of executing 9500 query. At first select primary_key from your table and then copy values to this query:

UPDATE table SET column1 = XXX WHERE primary_key IN (p1, p2, p3, ...);

Related questions

How to switch Keyspace in Cassandra using CQL?

I used USE billKeyspace; to enter a keyspace and start using it. Now I want to exit this keyspace and enter another keyspace. How to do that? If I use exit; or quit; it exits out of cql session itself …

Read More
Cassandra IN clause on index

Assume a simple table with one insert (or without this insert, doesn't really matter). CREATE TABLE test ( x int, y int, z int, PRIMARY KEY (x, y, z) ); create index z_index on test (z); insert into test(x, y, …

Read More
Cassandra order and clustering key

I have this table: CREATE TABLE custumer_events_service.events_by_websiteId_time( "event_id" text, "currentTime" timestamp, "websiteId" varchar, OTHER COLUMNS ... PRIMARY KEY(event_id, websiteId, currentTime) ) In this case, would I get 10000 rows ordered by currentime when I …

Read More