natural order is for column names, not values
2010/3/22 Juan Manuel García del Moral <juanman...@taringa.net>: > 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 <jbel...@gmail.com> >> >> You have to fetch the columns and sort client-side, for now. >> >> 2010/3/22 Juan Manuel García del Moral <juanman...@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 >> > >> > > >