get ordered by value

[Juan Manuel García del Moral]

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