Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of abassiri@gmail.com designates
 209.85.213.172 as permitted sender)
MIME-Version: 1.0
From: Ali Basiri <abassiri@gmail.com>
Date: Tue, 13 Mar 2012 14:28:02 -0700
Message-ID: 
 <CAPOfGNcDSKgvyqZag3veNHqfDbrsrmVn29Qd_ANdcsAzXOxetQ@mail.gmail.com>
Subject: Composite Key Query in CLI
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=e89a8fb1ede0d1600c04bb268912

--e89a8fb1ede0d1600c04bb268912
Content-Type: text/plain; charset=ISO-8859-1

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.

--e89a8fb1ede0d1600c04bb268912
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hey,<div><br></div><div>I&#39;m have a set of composite keys with data and =
trying to query them through the CLI. However, the result set returned is a=
lways empty.</div><div><br></div><div>The schema is like this:</div><div>

<br></div><div><div>=A0 =A0ColumnFamily: Routes</div><div>=A0 =A0 =A0 Key V=
alidation Class: org.apache.cassandra.db.marshal.CompositeType(org.apache.c=
assandra.db.marshal.TimeUUIDType,org.apache.cassandra.db.marshal.IntegerTyp=
e)</div>

<div>=A0 =A0 =A0 Default column value validator: org.apache.cassandra.db.ma=
rshal.UTF8Type</div><div>=A0 =A0 =A0 Columns sorted by: org.apache.cassandr=
a.db.marshal.UTF8Type</div><div>=A0=A0 =A0 =A0Row Cache Provider: org.apach=
e.cassandra.cache.ConcurrentLinkedHashCacheProvider</div>

<div>=A0 =A0 =A0 ...</div></div><div><br></div><div>The Data:</div><div>---=
----------------</div><div><div>RowKey: fd24a000-6d51-11e1-a260-109addb2747=
3:4</div><div>=3D&gt; (column=3Denabled, value=3Dtrue, timestamp=3D13316734=
84419000)</div>

<div>=3D&gt; (column=3DproviderId, value=3D0575af10-6d52-11e1-a260-109addb2=
7473, timestamp=3D1331673484419001)</div><div>-------------------</div><div=
>RowKey: fd24a000-6d51-11e1-a260-109addb27473:5</div><div>=3D&gt; (column=
=3Denabled, value=3Dtrue, timestamp=3D1331673476181000)</div>

<div>=3D&gt; (column=3DproviderId, value=3D0086b6c0-6d52-11e1-a260-109addb2=
7473, timestamp=3D1331673476181001)</div><div>-------------------</div></di=
v><div><br></div><div><br></div><div>The Query:</div><div>&gt; =A0get Route=
s[&#39;fd24a000-6d51-11e1-a260-109addb27473:4&#39;];</div>

<div>Returned 0 results.</div><div>Elapsed time: 4 msec(s).</div><div><br><=
/div><div>The cli correctly identifies the composite key types if I type th=
em wrong. From example an &#39;a&#39; instead of the &#39;4&#39;.</div>

<div><br></div><div>What am I doing wrong?</div><div><br></div><div>Thanks.=
</div>

--e89a8fb1ede0d1600c04bb268912--