incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tamar Fraenkel <ta...@tok-media.com>
Subject Re: Composite Key Query in CLI
Date Sat, 17 Mar 2012 19:22:54 GMT
I think you are doing ok,
I have a CF with the following schema
 ColumnFamily: tk_counters
      Key Validation Class:
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UUIDType)
      Default column value validator:
org.apache.cassandra.db.marshal.CounterColumnType
      Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
      Row cache size / save period in seconds / keys to save : 0.0/0/all
      Row Cache Provider:
org.apache.cassandra.cache.ConcurrentLinkedHashCacheProvider
      Key cache size / save period in seconds: 200000.0/14400
      GC grace seconds: 864000
      Compaction min/max thresholds: 4/32
      Read repair chance: 1.0
      Replicate on write: true
      Bloom Filter FP chance: default
      Built indexes: []
      Compaction Strategy:
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy

*and the following cli query:*
get tk_counters['d:9eff24f7-949f-487b-a566-0dedd07656ce'];
*returns:*
=> (counter=no, value=1)
=> (counter=yes, value=2)
Returned 2 results.



*Tamar Fraenkel *
Senior Software Engineer, TOK Media

[image: Inline image 1]

tamar@tok-media.com
Tel:   +972 2 6409736
Mob:  +972 54 8356490
Fax:   +972 2 5612956





On Tue, Mar 13, 2012 at 11:28 PM, Ali Basiri <abassiri@gmail.com> wrote:

> Hey,
>
> I'm have a set of composite keys with data and trying to query them
> through the CLI. However, the result set returned is always empty.
>
> The schema is like this:
>
>    ColumnFamily: Routes
>       Key Validation Class:
> org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.TimeUUIDType,org.apache.cassandra.db.marshal.IntegerType)
>       Default column value validator:
> org.apache.cassandra.db.marshal.UTF8Type
>       Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
>       Row Cache Provider:
> org.apache.cassandra.cache.ConcurrentLinkedHashCacheProvider
>       ...
>
> The Data:
> -------------------
> RowKey: fd24a000-6d51-11e1-a260-109addb27473:4
> => (column=enabled, value=true, timestamp=1331673484419000)
> => (column=providerId, value=0575af10-6d52-11e1-a260-109addb27473,
> timestamp=1331673484419001)
> -------------------
> RowKey: fd24a000-6d51-11e1-a260-109addb27473:5
> => (column=enabled, value=true, timestamp=1331673476181000)
> => (column=providerId, value=0086b6c0-6d52-11e1-a260-109addb27473,
> timestamp=1331673476181001)
> -------------------
>
>
> The Query:
> >  get Routes['fd24a000-6d51-11e1-a260-109addb27473:4'];
> Returned 0 results.
> Elapsed time: 4 msec(s).
>
> The cli correctly identifies the composite key types if I type them wrong.
> From example an 'a' instead of the '4'.
>
> What am I doing wrong?
>
> Thanks.
>

Mime
View raw message