cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Burton <bur...@spinn3r.com>
Subject Different TTLs for different columns requires two INSERTs?
Date Sat, 12 Jul 2014 23:23:28 GMT
I have a column that I would like to have a different TTL than the whole
row.

because of the cassandra USING TTL clause I don't think this is possible to
do with one INSERT.

It seems like I need to have TWO inserts doing this… One for all the
columns with the first TTL, and then another insert with the columns having
the second TTL.

And of course, you would want this to be atomic, so that means a batch,
with slows things down.

Am I correct ?  This is what the documentation would have me believe.

This seems to be a design flaw.  It seems to me that you should be able to
specify the TTLs on the columns…

something like

update foo set bar='bar' with TTL=60, cat='cat' with TTL=120;

...

-- 

Founder/CEO Spinn3r.com
Location: *San Francisco, CA*
blog: http://burtonator.wordpress.com
… or check out my Google+ profile
<https://plus.google.com/102718274791889610666/posts>
 <http://spinn3r.com>

Mime
View raw message