We have a table as below.
CREATE TABLE keyspace.table ( empid text, year int, inserted_date date, joining_date timestamp, grade text, PRIMARY KEY ((empid, year), inserted_date, joining_date, grade) ) WITH CLUSTERING ORDER BY (inserted_date DESC, joining_date DESC, flag grade) ;
There has been some wrong data entry for few columns and now we want to update those columns values.
Instead of <<null>> column value they have inserted as 'null' string value. This table has billions of rows and We want to unset/insert null value for these columns for entire table.
What is the best way to do this ?.It is difficult to find the primary key for all rows.
we want it to be corrected as below or unset these columns as they are null.