Thanks. I’ll probably file a bug for this, assuming one doesn’t already exist.
On Sun, Nov 16, 2014 at 6:20 AM, Eric Stevens <migh...@gmail.com> wrote: > I'm not aware of a way to query TTL or writetime on collections from CQL > yet. You can access this information from Thrift though. > > On Sat Nov 15 2014 at 12:51:55 AM DuyHai Doan <doanduy...@gmail.com> > wrote: > >> Why don't you use map to store write time as value and data as key? >> Le 15 nov. 2014 00:24, "Kevin Burton" <bur...@spinn3r.com> a écrit : >> >> I’m trying to build a histograph in CQL for various records. I’d like to >>> keep a max of ten items or items with a TTL. but if there are too many >>> items, I’d like to trim it so the max number of records is about 20. >>> >>> So if I exceed 20, I need to removed the oldest records. >>> >>> I’m using a set append so each member of the set has a different write >>> time and ttl. >>> >>> But I can’t figure out how to compute the writetime() of each set >>> member since the CQL write time only takes a column reference. >>> >>> Any advice? Seems like I’m an edge case. >>> >>> Plan B is to upgrade everything to 2.1 and I can use custom datatypes >>> and just store the write times myself, but that takes a while. >>> >>> -- >>> >>> 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> >>> >>> -- 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>