Re: possible to have TTL on individual collection values?

2014-07-17 Thread Ben Bromhead
Create a table with a set as one of the columns using cqlsh, populate with a 
few records.

Connect using the cassandra-cli, run list on your table/cf and you'll see how 
the sets work. 


Ben Bromhead
Instaclustr | www.instaclustr.com | @instaclustr | +61 415 936 359


On 13/07/2014, at 11:19 AM, Kevin Burton bur...@spinn3r.com wrote:

 
 
 
 On Sat, Jul 12, 2014 at 6:05 PM, Keith Wright kwri...@nanigans.com wrote:
 Yes each item in the set can have a different TTL so long as they are 
 upserted with commands having differing TTLs. 
 
 
 Ah… ok. So you can just insert them with unique UPDATE/INSERT commands with 
 different USING TTLs and it will work.  That makes sense.
 You should read about how collections/maps work in CQL3 in terms of their 
 CQL2 structure.
 
 Definitely.  I tried but the documentation is all over the map.  This is one 
 of the problems with Cassandra IMO.  It's evolving so fast that it's 
 difficult to find the correct documentation.
  
 -- 
 
 Founder/CEO Spinn3r.com
 Location: San Francisco, CA
 blog: http://burtonator.wordpress.com
 … or check out my Google+ profile
 
 



possible to have TTL on individual collection values?

2014-07-12 Thread Kevin Burton
If I have a settext.. can I have the individual members TTL , and not
just the whole 'column' ?

It's interesting considering I can use the UPDATE form whereby I just add
members to the set and have a TTL on that value… which would seem to imply
that I can set individual values.

Kevin

-- 

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


Re: possible to have TTL on individual collection values?

2014-07-12 Thread Keith Wright
Yes each item in the set can have a different TTL so long as they are upserted 
with commands having differing TTLs.  You should read about how 
collections/maps work in CQL3 in terms of their CQL2 structure.

On Jul 12, 2014 7:32 PM, Kevin Burton bur...@spinn3r.com wrote:
If I have a settext.. can I have the individual members TTL , and not just 
the whole 'column' ?

It's interesting considering I can use the UPDATE form whereby I just add 
members to the set and have a TTL on that value… which would seem to imply that 
I can set individual values.

Kevin

--

Founder/CEO Spinn3r.comhttp://Spinn3r.com
Location: San Francisco, CA
blog: http://burtonator.wordpress.com
… or check out my Google+ 
profilehttps://plus.google.com/102718274791889610666/posts
[http://spinn3r.com/images/spinn3r.jpg]http://spinn3r.com


Re: possible to have TTL on individual collection values?

2014-07-12 Thread Kevin Burton
On Sat, Jul 12, 2014 at 6:05 PM, Keith Wright kwri...@nanigans.com wrote:

  Yes each item in the set can have a different TTL so long as they are
 upserted with commands having differing TTLs.


Ah… ok. So you can just insert them with unique UPDATE/INSERT commands with
different USING TTLs and it will work.  That makes sense.

 You should read about how collections/maps work in CQL3 in terms of their
 CQL2 structure.

Definitely.  I tried but the documentation is all over the map.  This is
one of the problems with Cassandra IMO.  It's evolving so fast that it's
difficult to find the correct documentation.

-- 

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