I understand, but there isn't a way to define a data schema, and get it sorted in the insertion,so then the natural order would match what I need to query?



2010/3/22 Jonathan Ellis <jbellis@gmail.com>
You have to fetch the columns and sort client-side, for now.

2010/3/22 Juan Manuel García del Moral <juanmanuel@taringa.net>:
> 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
>
>