@B Todd Burruss:
Regarding the use cases, I think they are pretty common. At least I see its
usages very frequently in my project. Lets say when the application needs
to store a timeline of bookmark activity by a user on certain items then if
I could store the activity data containing columns(with
One example could be to identify when a row was last updated. For example,
if I have a column family for storing users, the row key is a user ID and
the columns are values for that user, e.g. natural column names would be
"firstName", "lastName", "address", etc; column names don't naturally
include
trying to think of a use case where you would want to order by
timestamp, and also have unique column names for direct access.
not really trying to challenge the use case, but you can get ordering
by timestamp and still maintain a "name" for the column using
composites. if the first component of t
You probably already know this but I'm pretty sure it wouldn't be a trivial
change, since to efficiently lookup a column by name requires the columns
to be ordered by name. A separate index would be needed in order to provide
lookup by column name if the row was sorted by timestamp (which is the wa
dra.apache.org<mailto:user@cassandra.apache.org>"
mailto:user@cassandra.apache.org>>
Date: Friday, October 12, 2012 12:13 AM
To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>"
mailto:user@cassandra.apache.org>>
Subject: Re: Option for ordering columns by time
"Make column timestamps optional"- kidding me, right ?:) I do understand
that this wont be possible as then cassandra wont be able to distinguish
the latest among several copies of same column. I dont mean that. I just
want the while ordering the columns, Cassandra(in an optional mode per CF)
shou
Without thinking too deeply about it, this is basically equivalent to
disabling timestamps for a column family and using timestamps for column
names, though in a very indirect (and potentially confusing) manner. So,
if you want to open a ticket, I would suggest framing it as "make column
timestamp
I think that would be cool.
/Martin Koch - Issuu - Senior Software Architect
On Wed, Oct 10, 2012 at 11:44 AM, Ertio Lew wrote:
> I think Cassandra should provide an configurable option on per column
> family basis to do columns sorting by time-stamp rather than column names.
> This would be re
I think Cassandra should provide an configurable option on per column
family basis to do columns sorting by time-stamp rather than column names.
This would be really helpful to maintain time-sorted columns without using
up the column name as time-stamps which might otherwise be used to store
most r
If you mean order by the column timestamp (as passed by the client) that it not
possible.
Can you use your own timestamps as the column name and store them as long
values ?
Aaron
On 25 Mar 2011, at 09:30, Narendra Sharma wrote:
> Cassandra 0.7.4
> Column names in my CF are of type byte[] bu
Cassandra 0.7.4
Column names in my CF are of type byte[] but I want to order columns by
timestamp. What is the best way to achieve this? Does it make sense for
Cassandra to support ordering of columns by timestamp as option for a column
family irrespective of the column name type?
Thanks,
Naren
11 matches
Mail list logo
