Hello, I have a table with 3m records and say 3m recs have empty string on
which an MView is built upon.
create table t
( c1 int, c2 text, primary key(c1));
create materialized view mv as select c2,c1 from t
WHEREc2 IS NOT NULL AND c1 IS NOT NULL
PRIMARY KEY (c2, c1);
There are recs inserted as - insert into t(c1,c2) values(1,'');
I know UNSET option can be used to not have null value and also c2 can be
removed from the insert statement. But what I am looking for is a way to
update t to set til for c2 where it is empty string. One way is to scan the
whole table and store the c1's which have c2 as empty string and then use
c1 to update. But this would require some coding efforts, any easy way to
update the table using cql or less effort ways?
--
Regards,
Ayub
