incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Juan Manuel García del Moral <juanman...@taringa.net>
Subject Re: get ordered by value
Date Mon, 22 Mar 2010 20:21:14 GMT
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
> >
> >
>

Mime
View raw message