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 mishra.vivs@gmail.com
 designates 209.85.160.44 as permitted sender)
MIME-Version: 1.0
Date: Tue, 9 Oct 2012 15:24:36 +0530
Message-ID: 
 <CANJo1uDH8m0UZrGgNBBigoK6JFQ56CkhaiFb0K-MFRfSxzcMrg@mail.gmail.com>
Subject: ORDER by support over clustered column of primary key.
From: Vivek Mishra <mishra.vivs@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=047d7b33d9366775d604cb9d53a4

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

Hi,

Create a column family:
------------------------------------

CREATE TABLE altercations (
       instigator text,
       started_at timestamp,
       ships_destroyed int,
       energy_used float,
       alliance_involvement boolean,
       PRIMARY KEY (instigator,started_at,ships_destroyed);

I think "instigator" is part of primary compound key.

Insert :
---------

   INSERT INTO altercations (instigator, started_at, ships_destroyed,
                             energy_used, alliance_involvement)
                     VALUES ('Jayne Cobb', '2012-07-24', 2, 4.6, 'false');


Select:

SELECT * FROM altercations
          WHERE instigator='Jayne Cobb' ORDER BY started_at;

It works. But when i try:

SELECT * FROM altercations
          WHERE instigator='Jayne Cobb' ORDER BY instigator;

It gives me:

{Bad Request: Order by is currently only supported on the clustered columns
of the PRIMARY KEY, got instigator}


Any idea, what am i missing?

-Vivek

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

<div>Hi,</div><div><br></div><div>Create a column family:</div><div>-------=
-----------------------------</div><div><br></div><div><div>CREATE TABLE al=
tercations (</div><div>=A0 =A0 =A0 =A0instigator text,</div><div>=A0 =A0 =
=A0 =A0started_at timestamp,</div>
<div>=A0 =A0 =A0 =A0ships_destroyed int,</div><div>=A0 =A0 =A0 =A0energy_us=
ed float,</div><div>=A0 =A0 =A0 =A0alliance_involvement boolean,</div><div>=
=A0 =A0 =A0 =A0PRIMARY KEY (instigator,started_at,ships_destroyed);</div></=
div><div><br></div><div>I think &quot;instigator&quot; is part of primary c=
ompound key.=A0</div>
<div><br></div><div>Insert :</div><div>---------</div><div><br></div><div><=
div>=A0 =A0INSERT INTO altercations (instigator, started_at, ships_destroye=
d,</div><div>=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0ene=
rgy_used, alliance_involvement)</div>
<div>=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0VALUES (&#39;Jayne Cobb&#39=
;, &#39;2012-07-24&#39;, 2, 4.6, &#39;false&#39;);</div></div><div><br></di=
v><div><br></div><div><br></div><div><br></div><div>Select:</div><div><br><=
/div><div><div>SELECT * FROM altercations</div>
<div>=A0 =A0 =A0 =A0 =A0 WHERE instigator=3D&#39;Jayne Cobb&#39; ORDER BY s=
tarted_at;</div></div><div><br></div><div>It works. But when i try:</div><d=
iv><br></div><div><div>SELECT * FROM altercations</div><div>=A0 =A0 =A0 =A0=
 =A0 WHERE instigator=3D&#39;Jayne Cobb&#39; ORDER BY instigator;</div>
</div><div><br></div><div>It gives me:</div><div><br></div><div><div>{Bad R=
equest: Order by is currently only supported on the clustered columns of th=
e PRIMARY KEY, got instigator}</div></div><div><br></div><div><br></div>
<div>Any idea, what am i missing?</div><div><br></div><div>-Vivek</div><div=
><br></div>

--047d7b33d9366775d604cb9d53a4--