Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of ertiop93@gmail.com designates
 209.85.220.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <D41CC922-FD04-4AA0-A631-D8C8D1AE7495@thelastpickle.com>
References: <AANLkTi=97uFW6sxJPAWsh9SEpUeQ4h9G0++1SUv9KWUX@mail.gmail.com>
	<D41CC922-FD04-4AA0-A631-D8C8D1AE7495@thelastpickle.com>
Date: Wed, 10 Oct 2012 15:14:38 +0530
Message-ID: 
 <CADwHx2qrH1Pw2fQtu15OfuOx+9i+3FhUdBy0MLq687hA=_Jwyg@mail.gmail.com>
Subject: Re: Option for ordering columns by timestamp in CF
From: Ertio Lew <ertiop93@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=047d7b15ac579ace7a04cbb14da2

--047d7b15ac579ace7a04cbb14da2
Content-Type: text/plain; charset=ISO-8859-1

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 relevant column names useful for retrievals. Very frequently we need
to store data sorted in time order. Therefore I think this may be a very
general requirement & not specific to just my use-case alone.

Does it makes sense to create an issue for this ?


On Fri, Mar 25, 2011 at 2:38 AM, aaron morton <aaron@thelastpickle.com>wrote:

> 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[] 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
>
>

--047d7b15ac579ace7a04cbb14da2
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I think Cassandra should provide an configurable option on per column famil=
y basis to do columns sorting by=A0time-stamp=A0rather than column names. T=
his would be really helpful to maintain=A0time-sorted=A0columns without usi=
ng up the column name as=A0time-stamps=A0which might otherwise=A0be used=A0=
to store most relevant column names useful for retrievals. Very frequently =
we need to store data sorted in time order. Therefore I think this may be a=
 very general requirement &amp; not specific to just my=A0use-case=A0alone.=
<div>
<br></div><div>Does it makes sense to create an issue for this ?<br><div><b=
r></div><div><br><br><div class=3D"gmail_quote">On Fri, Mar 25, 2011 at 2:3=
8 AM, aaron morton <span dir=3D"ltr">&lt;<a href=3D"mailto:aaron@thelastpic=
kle.com" target=3D"_blank">aaron@thelastpickle.com</a>&gt;</span> wrote:<br=
>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">If you mean order by the column timestamp (a=
s passed by the client) that it not possible.<br>
<br>
Can you use your own timestamps as the column name and store them as long v=
alues ?<br>
<span class=3D"HOEnZb"><font color=3D"#888888"><br>
Aaron<br>
</font></span><div class=3D"HOEnZb"><div class=3D"h5"><br>
On 25 Mar 2011, at 09:30, Narendra Sharma wrote:<br>
<br>
&gt; Cassandra 0.7.4<br>
&gt; Column names in my CF are of type byte[] but I want to order columns b=
y timestamp. What is the best way to achieve this? Does it make sense for C=
assandra to support ordering of columns by timestamp as option for a column=
 family irrespective of the column name type?<br>

&gt;<br>
&gt; Thanks,<br>
&gt; Naren<br>
<br>
</div></div></blockquote></div><br></div></div>

--047d7b15ac579ace7a04cbb14da2--