My understanding is that yes you need two inserts which you could do as part of 
a batch.

On Jul 12, 2014 7:24 PM, Kevin Burton <bur...@spinn3r.com> wrote:
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<http://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/images/spinn3r.jpg]<http://spinn3r.com>

Reply via email to