set a value to null in cassandra with cql

Question

How can I set a value of a row to null in cassandra? For example I have a table like this: ``` CREATE TABLE instruments ( code text, ric text, primary key (code) ) ``` if I want an element to have a particular `ric`: ``` update instruments set ric='test' where code='code'; ``` But what about setting `ric` to `None`?

Accepted Answer

It might be done with `DELETE` CQL command:

```
DELETE ric FROM instruments WHERE code='code';
```

set a value to null in cassandra with cql

Solution

Problem