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 todd.nine@gmail.com designates
 209.85.160.177 as permitted sender)
MIME-Version: 1.0
Sender: todd.nine@gmail.com
Date: Sat, 30 Aug 2014 18:59:10 -0600
Message-ID: 
 <CAHLkSEomP1WT1+PCyVuiAELzczeVQ1ZEP7MjJpcTSzj2fmUR4A@mail.gmail.com>
Subject: Help with migration from Thrift to CQL3 on Cassandra 2.0.10
From: Todd Nine <toddnine@apache.org>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a11c20d3ce61bc60501e26454

--001a11c20d3ce61bc60501e26454
Content-Type: text/plain; charset=UTF-8

Hi all,
  I'm working on transferring our thrift DAOs over to CQL.  It's going
well, except for 2 cases that both use multi get.  The use case is very
simple.  It is a narrow row, by design, with only a few columns.  When I
perform a multiget, I need to get up to 1k rows at a time.  I do not want
to turn these into a wide row using scopeId and scopeType as the row key.


On the physical level, my Column Family needs something similar to the
following format.


scopeId, scopeType, nodeId, nodeType :{ timestamp: 0x00 }


I've defined by table with the following CQL.


CREATE TABLE IF NOT EXISTS Graph_Marked_Nodes
( scopeId uuid, scopeType varchar, nodeId uuid, nodeType varchar, timestamp
bigint,
PRIMARY KEY ((scopeId , scopeType, nodeId, nodeType))
)WITH caching = 'all'


This works well for inserts deletes and single reads.  I always know the
scopeId, scopeType, nodeId, and nodeType, so I want to return the timestamp
columns.  I thought I could use the IN operation and specify the pairs of
nodeId and nodeTypes I have as input, however this doesn't work.

Can anyone give me a suggestion on how to perform a multiget when I have
several values for the nodeId and the nodeType?  This read occurs on every
read of edges so making 1k trips is not going to work from a performance
perspective.

Below is the query I've tried.

SELECT timestamp FROM  Graph_Marked_Nodes WHERE scopeId = ? AND scopeType =
? AND nodeId IN (uuid1, uuid2, uuid3) AND nodeType IN ('foo','bar')

I've found this issue, which looks like it's a solution to my problem.

https://issues.apache.org/jira/browse/CASSANDRA-6875

However, I'm not able to get the syntax in the issue description to work
either.  Any input would be appreciated!

Cassandra: 2.0.10
Datastax Driver: 2.1.0

Thanks,
Todd

--001a11c20d3ce61bc60501e26454
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi all,<div>=C2=A0 I&#39;m working on transferring our thr=
ift DAOs over to CQL. =C2=A0It&#39;s going well, except for 2 cases that bo=
th use multi get. =C2=A0The use case is very simple. =C2=A0It is a narrow r=
ow, by design, with only a few columns. =C2=A0When I perform a multiget, I =
need to get up to 1k rows at a time. =C2=A0I do not want to turn these into=
 a wide row using scopeId and scopeType as the row key.</div>
<div><br></div><div><br></div><div>On the physical level, my Column Family =
needs something similar to the following format.</div><div><br></div><div><=
br></div><div>scopeId, scopeType, nodeId, nodeType :{ timestamp: 0x00 }</di=
v>
<div><br></div><div><br></div><div>I&#39;ve defined by table with the follo=
wing CQL.</div><div><br></div><div><br></div><div><div>CREATE TABLE IF NOT =
EXISTS Graph_Marked_Nodes=C2=A0</div><div>( scopeId uuid, scopeType varchar=
, nodeId uuid, nodeType varchar, timestamp bigint, =C2=A0</div>
<div>PRIMARY KEY ((scopeId , scopeType, nodeId, nodeType))=C2=A0</div><div>=
)WITH caching =3D &#39;all&#39;</div></div><div><br></div><div><br></div><d=
iv>This works well for inserts deletes and single reads. =C2=A0I always kno=
w the scopeId, scopeType, nodeId, and nodeType, so I want to return the tim=
estamp columns. =C2=A0I thought I could use the IN operation and specify th=
e pairs of nodeId and nodeTypes I have as input, however this doesn&#39;t w=
ork. =C2=A0</div>
<div><br></div><div>Can anyone give me a suggestion on how to perform a mul=
tiget when I have several values for the nodeId and the nodeType? =C2=A0Thi=
s read occurs on every read of edges so making 1k trips is not going to wor=
k from a performance perspective.</div>
<div><br></div><div>Below is the query I&#39;ve tried.</div><div><br></div>=
<div>SELECT timestamp FROM =C2=A0Graph_Marked_Nodes WHERE scopeId =3D ? AND=
 scopeType =3D ? AND nodeId IN (uuid1, uuid2, uuid3) AND nodeType IN (&#39;=
foo&#39;,&#39;bar&#39;)</div>
<div><br></div><div>I&#39;ve found this issue, which looks like it&#39;s a =
solution to my problem.</div><div><br></div><div><a href=3D"https://issues.=
apache.org/jira/browse/CASSANDRA-6875">https://issues.apache.org/jira/brows=
e/CASSANDRA-6875</a><br>
</div><div><br></div><div>However, I&#39;m not able to get the syntax in th=
e issue description to work either. =C2=A0Any input would be appreciated!</=
div><div><br></div><div>Cassandra: 2.0.10</div><div>Datastax Driver: 2.1.0<=
/div>
<div><br></div><div>Thanks,</div><div>Todd</div><div><br></div><div><br></d=
iv><div><br></div><div><br></div></div>

--001a11c20d3ce61bc60501e26454--