cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ayub M <hia...@gmail.com>
Subject Easy way to update a huge table without PK
Date Wed, 16 Jan 2019 02:16:06 GMT
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

Mime
View raw message