Return-Path: 
 <user-return-3451-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
Delivered-To: apmail-cassandra-user-archive@www.apache.org
Received: (qmail 25310 invoked from network); 22 Mar 2010 20:09:26 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 22 Mar 2010 20:09:26 -0000
Received: (qmail 28521 invoked by uid 500); 22 Mar 2010 20:09:25 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 28469 invoked by uid 500); 22 Mar 2010 20:09:25 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 28461 invoked by uid 99); 22 Mar 2010 20:09:25 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 22 Mar 2010 20:09:25 +0000
X-ASF-Spam-Status: No, hits=2.9 required=10.0
	tests=HTML_MESSAGE,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Received: from [74.125.83.172] (HELO mail-pv0-f172.google.com) (74.125.83.172)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 22 Mar 2010 20:09:17 +0000
Received: by pvh1 with SMTP id 1so3099593pvh.31
        for <user@cassandra.apache.org>; Mon, 22 Mar 2010 13:08:55 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.141.12.8 with SMTP id p8mr913062rvi.160.1269288535500;
 Mon, 22
	Mar 2010 13:08:55 -0700 (PDT)
Date: Mon, 22 Mar 2010 17:08:55 -0300
Message-ID: <9ad76c4d1003221308u2f8f5d0eg41138be899417e62@mail.gmail.com>
Subject: get ordered by value
From: =?ISO-8859-1?Q?Juan_Manuel_Garc=EDa_del_Moral?= <juanmanuel@taringa.net>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=000e0cd11a8246a82c04826944e8

--000e0cd11a8246a82c04826944e8
Content-Type: text/plain; charset=ISO-8859-1

Hello

I have this:

get SocialAds.Anonimos['3539792'];
=> (super_column=Tag,
     (column=1036, value=5, timestamp=1001181414)
     (column=116, value=2, timestamp=1001181414)
     (column=121988, value=2, timestamp=1001181413)
     (column=13838, value=3, timestamp=1001181416)
     (column=14105, value=2, timestamp=1001181413)
     (column=169095, value=2, timestamp=1001181414)
     (column=30253, value=2, timestamp=1001181413)
     (column=350737, value=1, timestamp=1001181341)
     (column=350738, value=1, timestamp=1001181341))

I would need to get the column with the highest value for that CF, this is
something I have to do in the get() or in the data schema?

my schema is:

<Keyspace Name="SocialAds">

<ColumnFamily ColumnType="Super"
                    CompareWith="UTF8Type"
                    CompareSubcolumnsWith="UTF8Type"
                    Name="Anonimos"
                    RowsCached="1000"
                    KeysCached="50%"
                    Comment="A column family with supercolumns, whose column
and subcolumn names are UTF8 strings"/>

<ReplicaPlacementStrategy>org.apache.cassandra.locator.RackUnawareStrategy</ReplicaPlacementStrategy>
      <ReplicationFactor>1</ReplicationFactor>

<EndPointSnitch>org.apache.cassandra.locator.EndPointSnitch</EndPointSnitch>
</Keyspace>


Any ideas?

Thanks in advance

Juan

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

Hello<br><br>I have this:<br><br>get SocialAds.Anonimos[&#39;3539792&#39;];=
<br>=3D&gt; (super_column=3DTag,<br>=A0=A0=A0=A0 (column=3D1036, value=3D5,=
 timestamp=3D1001181414)<br>=A0=A0=A0=A0 (column=3D116, value=3D2, timestam=
p=3D1001181414)<br>=A0=A0=A0=A0 (column=3D121988, value=3D2, timestamp=3D10=
01181413)<br>
=A0=A0=A0=A0 (column=3D13838, value=3D3, timestamp=3D1001181416)<br>=A0=A0=
=A0=A0 (column=3D14105, value=3D2, timestamp=3D1001181413)<br>=A0=A0=A0=A0 =
(column=3D169095, value=3D2, timestamp=3D1001181414)<br>=A0=A0=A0=A0 (colum=
n=3D30253, value=3D2, timestamp=3D1001181413)<br>=A0=A0=A0=A0 (column=3D350=
737, value=3D1, timestamp=3D1001181341)<br>
=A0=A0=A0=A0 (column=3D350738, value=3D1, timestamp=3D1001181341))<br><br>I=
 would need to get the column with the highest value for that CF, this is s=
omething I have to do in the get() or in the data schema?<br><br>my schema =
is:<br><br>
&lt;Keyspace Name=3D&quot;SocialAds&quot;&gt;<br><br>&lt;ColumnFamily Colum=
nType=3D&quot;Super&quot;<br>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0 CompareWith=3D&quot;UTF8Type&quot;<br>=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 CompareSubcolumnsWith=3D&quot;UTF8Type&qu=
ot;<br>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 Name=3D&quot;Anon=
imos&quot;<br>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 Row=
sCached=3D&quot;1000&quot;<br>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0 KeysCached=3D&quot;50%&quot;<br>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0 Comment=3D&quot;A column family with supercolum=
ns, whose column and subcolumn names are UTF8 strings&quot;/&gt;<br>
<br>&lt;ReplicaPlacementStrategy&gt;org.apache.cassandra.locator.RackUnawar=
eStrategy&lt;/ReplicaPlacementStrategy&gt;<br>=A0=A0=A0=A0=A0 &lt;Replicati=
onFactor&gt;1&lt;/ReplicationFactor&gt;<br>=A0=A0=A0=A0=A0 &lt;EndPointSnit=
ch&gt;org.apache.cassandra.locator.EndPointSnitch&lt;/EndPointSnitch&gt;<br=
>
&lt;/Keyspace&gt;<br><br><br>Any ideas?<br><br>Thanks in advance<br><br>Jua=
n<br><br>

--000e0cd11a8246a82c04826944e8--