Re: Is there any way I could use keys of other rows as column names that could be sorted according to time ?

[Aaron Morton]

You could make the time an a fixed width integer and prefix your row keys with it, then set the comparotor to ascii or utf. 

Some issues:

- Will you have time collisions ? 

- Not sure what your are storing in the super columns, but their are limitations http://wiki.apache.org/cassandra/CassandraLimitations

- If you are using cassandra 0.7, have you looked at the secondary indexes ? http://www.riptano.com/blog/whats-new-cassandra-07-secondary-indexes

If you provide some more info on the problem your trying to solve we may be able to help some more. 

Cheers

Aaron

On 14 Jan, 2011,at 04:27 PM, Aklin_81 <asdk...@gmail.com> wrote:

I would like to keep the reference of other rows as names of super
column and sort those super columns according to time.
Is there any way I could implement that ?

Thanks in advance!