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.
Current data:
col1 col2
null null
we want it to be corrected as below or unset these columns as they are null.
col1 col2
<<null> <<null>>
