Hi all,
I am using C* 1.2.4 with CQL3 and am taking advantage of the new collection support. One usage case I have is that I want a set of text and I need to know the time when each item in the set was written. If I understand CQL3 correctly, the underlying data engine utilizes composites for sets and maps (where sets are just maps with no values). I was hoping that I could store my text items as a set and then somehow get the write time of each item via WRITETIME. Instead it appears that I need to use a map of TEXT to TIMESTAMP which will increase my data set. Does anyone know I way I could expose the write time of set items?
Thanks!
Keith Wright 's gravatar image asked May 23 2013 at 08:18 in Cassandra-User by Keith Wright

1 Answers

You cannot currently unfortunately.
The problem is really just an API one. Since currently you can only ever
query a full collection, you cannot apply writeTime() to only an element,
and applying it to the whole collection doesn't make sense, in the sense
that each element have a write time as you said.
We'll likely allow to query individual elements of collections in the
future, at which point allowing to get the write time of said individual
will work. But let's say that today we just don't have a syntax yet to make
it work.
Sylvain
Sylvain Lebresne 's gravatar image answered May 23 2013 at 09:10 by Sylvain Lebresne

Related Discussions

  • Any Limits On Number Of Items In A Collection Column Type in Cassandra-user

  • Hi, I have a column daycount list. The column is storing a count. Every few secs a new count is appended. The total count for the day is the sum of all items in the list. My application logs indicate I wrote about 110000 items to the column for a particular row. Assume row key is day_timestamp. But when I do a read on the column I get back a list with only 43000 items. Checked with...

  • Deleting Old Items During Compaction (WAS: Deleting Old Items) in Cassandra-user

  • Hi, We looking for solution for same problem. We have a wide column family with counters and we want to delete old data like 1 months old. One of potential ideas was to implement hook in compaction code and drop column which we don't need. Is this a viable option? Thanks, Ilya From: aaron morton [mailto:[email protected]] Sent: Tuesday, February 12, 2013 9:01 AM To: [email protected]..

  • CQL & Selecting Individual Items From A Map in Cassandra-user

  • I was wondering if anybody could explain the rationale behind disallowing selection of individual elements from a map in CQL and why an entire map must be retrieved at once when items are stored as distinct columns? Are there any plans to allow individual selection? Liam Stewart :: [email protected]..

  • Deleting Old Items in Cassandra-user

  • Hi, I would like to know if there is a way to delete old/unused data easily ? I know about TTL but there are 2 limitations of TTL: - AFAIK, there is no TTL on counter columns - TTL need to be defined at write time, so it's too late for data already inserted. I also could use a standard "delete" but it seems inappropriate for such a massive. In some cases, I don't know the row key and would like...

  • Data Model Question : Finding Out The N Most Recent Changes Items in Cassandra-user

  • I have an application that need to find out the n most recent modified files for a given user id. I started out few tables but still couldn't get what i want, I hope someone get point to some right direction... See my tables below. #1 won't work, because file_id's timeuuid contains creation time, not the modification time. #2 won't work, because i can't order by a non primary key column...

  • Store Individual Inventory Items In A Table, How To Assign Them Correctly in Cassandra-user

  • Say I have 100 products in inventory, instead of having a counter I want to create 100 rows per inventory item. When someone purchases a product, how can I correctly assign that customer a product from inventory without having any race conditions etc? Thanks....

  • Can't Get Items Out Of A Set? in Python

  • Hello, all. Is it possible to get an object out of a set() given another object that has the same hash code and equality (__hash__() and __eq__() return the same)? You can't do this with Java Sets either and I've needed it on multiple occasions. Doesn't it seem like it would be useful? Consider: class Person: def __init__(self, id, name): self.id = id self.name = name def __hash__...

  • Set Expiring Items in Redis-db

  • Hello, I'm trying to do the following: have a set of short strings (as a queue) with expiration times (have items get dropped if they aren't processed fast enough). It's probably because I'm well tired now, but I can't seem to find a way to do that: SADD queue v4lu3 and then EXPIRE that new item. Is there a way, a workaround or just plain nothing? Thank you for your time and good night....

  • Changing Order Of Collection Items in Isis-users

  • Hi, Anybody a great idea for changing item order in a sorted set using the wicket viewer? I have a rank-property in the database but how to easily manage the item order (move item(s) up/down single or multiple places)... Thanks, Erik...

  • How To Persist A List Of Items In A Domain Service in Isis-users

  • Good afternoon. I am trying to create a domain service with a method to finish a purchase. So, I have to set in the purchase a list of items, and I don't know how I do this. I imagine the interface with a field to find items and a table or a list showing the selected items by the user. Any tips? Thank you. Gabriel Malimpensa. Sao Carlos, Sao Paulo, Brazil....

  • [[email protected]] SSL & Nonsecure Items in Httpd-users

  • I'm currently wrestling with the set up of SSL on Apache (on Windows) and I have the server up and running and accepting https connections etc. When I first connect to the website from my browser (IE in this case) I get the warning regarding the certificate (I have set up a test certificate), which is fine. However every page I subsequently go to I get a "do you want to display nonsecure items" dialog...

  • Possible To Expire Set Items? in Redis-db

  • I'm new to Redis, and as far as I can tell, it seems like I'm looking for something like what SADDEX or SETNXEX would be. A way to add an item, only if it does not exist, and have it use the expiry feature without having to have logic on the client and another call to the database. I've seen the posts about SETNXEX and how adding a feature that is a simple combination of other features has ...

  • Boosting Newer Inserted Items In Search? in Lucene-solr-user

  • Hi! When doing a search we want to have a have parameters that we set of how to boost different scores. for example we want to have the ability to boost newer items in some case and in some not, like a sliding scale from only time to only relevancy. What is the best way of doing this, using Solrj? Regards Erik...

  • Getting List Of Items Spanning A Time Period in Couchdb-user

  • Hi, Am working on an hospital information system using couchdb and node.js. For this I need to get the list and number of patients in a given time period - usually a day. I can get the patients who were admitted or discharged in that time period. How to get the list of patients who were admitted earlier than the start of the period but who got discharged after the time period or who are not discharged...

  • Popularity Of Recommender Items in Mahout-user

  • Trying to come up with a relative measure of popularity for items in a recommender. Something that could be used to rank items. The user - item preference matrix would be the obvious thought. Just add the number of preferences per item. Maybe transpose the preference matrix (the temp DRM created by the recommender), then for each row vector (now that a row = item) grab the number of non zero preferences...

  • Repeating Blocks Of Items in Angularjs

  • hello, id appreciate some help on the following i have an array of objects, lets say var items = [{"id": 1, "name": "one"}, {"id": 2, "name": "two"},{"id": 3, "name": "three"},{"id": 4, "name": "four"},{"id": 5, "name": "five"}] now i need to create as many rows of TWO divs as necessary ... the final "pseudo" html should look like this 1 (one) 2 (two) ...

  • Performing DIH On Predefined List Of IDS in Lucene-solr-user

  • Relatively frequently (about a once a month) we need to reindex the data, by using DIH and copying the data from one index to another. Because of the fact that we have a large index, it could take from 12 to 24 hours to complete. At the same time the old index is being queried by users. Sometimes DIH could be interrupted at the middle, because of some unexpected exception caused by OutOfMemory...

  • Sessions in Php-general

  • Hi I am working on a Admin view of an Intranet site. They need to enter orders. An order can include many inventory items so I have divided it up to two pages. I have set up a first page session that passes the first page info onto the second page where the inventory items are addes to the order. I need to be able to add multple second pages while still maintaining the first page info and...

  • Idle Functionality in Redis-db

  • I have a patch I'd like to contribute, if you guys would like. This adds a new feature; I'm not sure if this conflicts with other development or sort of steps on other functionality but let me give you the background and what I did. For an e-commerce site I'm working on we needed a solution for fast server-side carts. After looking at a few options Redis made the most sense. We brought up...

  • Support For New Items In Set Type in Python

  • I have a bit of a specialized request. I'm reading a table of strings (specifically fixed length 36 char uuids generated via uuid.uuid4() in the standard library) from a file and creating a set out of it. Then my program is free to make whatever modifications to this set. When I go back to save this set, I'd like to be able to only save the new items. Currently I am creating a copy of the set as...

  • Changing Sort Order Of Items. in Mysql-general

  • I'm trying to create the most efficient way to allow a user to change the display order of a group of rows in a table. Lets say the basic table is: id group_id name sort_order The query to display it would be "SELECT id, name FROM mytable WHERE group_id = $x ORDER BY sort_order" Now when I display it they currenlty all have the same sort_order value so they come in the order ...

  • Calculation Of Top Popular Items in Mahout-user

  • Hello Mahout Group, which algorithm will calculate top popular numbers of items in Item Based Recommendation.? if my sample dataset structure is given below. #UserId,#ItemId,#Prefrence Thanks *Vignesh Prajapati* Tel: 9427415949 | [email protected] | www.vipras.com.co.in MYTK [image: Facebook] [image: Twitter] [image: LinkedIn] [image: about.me]...

  • Total Number Of Filtered Items in Angularjs

  • Hi My problem is this, I have the following code, which shows me a list of items and then makes me filter the solution chosen. http://jsfiddle.net/kSG2s/ He makes the filter as well. But I'd like to know the total number that item that are shown after the filter. How can I do this? Someone can help me?...

  • Evolution - Removal Of Deleted Items in Ubuntu-users

  • I was unable to empty the Deleted items file using Ubuntu 8.10 so I have just upgraded to 9.04 and the problem is still there. I have just checked and, to my horror, there are over 17.000 items there. Please advise me on how to rectify this problem. Norman...

  • Collation Order Of Items in Hbase-user

  • Is there any way to control introduce a different ordering scheme from the base comparable bytes? My use case is that I am using UTF-8 data for my keys, and I would like to have scans use UTF-8 collation. Could this be done by providing an alternate implementation of WritableComparable? Thanks in advance! --Tom...

  • How Can I Create A A Map Of BSONObjBuilder Using Std::map? in Mongodb-user

  • Hi, I would like to do something like this std::map items for (i = 0; i...