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] ta...@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 <abass...@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. >
<<tokLogo.png>>