Return-Path: 
 <user-return-37854-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
X-Original-To: apmail-cassandra-user-archive@www.apache.org
Delivered-To: apmail-cassandra-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 2293D10ACC
	for <apmail-cassandra-user-archive@www.apache.org>;
 Thu,  5 Dec 2013 17:58:43 +0000 (UTC)
Received: (qmail 32723 invoked by uid 500); 5 Dec 2013 17:58:40 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 32244 invoked by uid 500); 5 Dec 2013 17:58:37 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 32167 invoked by uid 99); 5 Dec 2013 17:58:36 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Dec 2013 17:58:36 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of rtfm.rtfm.rtfm@gmail.com
 designates 209.85.220.178 as permitted sender)
Received: from [209.85.220.178] (HELO mail-vc0-f178.google.com)
 (209.85.220.178)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Dec 2013 17:58:31 +0000
Received: by mail-vc0-f178.google.com with SMTP id lh4so13198174vcb.23
        for <user@cassandra.apache.org>; Thu, 05 Dec 2013 09:58:10 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type;
        bh=JIRPeiuNBSkHHGJ7fEDgqdehKFNE3WJKiXkE54JNWkk=;
        b=Pn23NzBlw+dKGHR5MaNnJUu9VJFQWZ0c0J7sxPLdmCS9J2Co+ao8nFsDmxldtyNTLq
         7OEtDpJb2A7t+OQbtrLh9fpLF4f8VutJ1eM66oNNR9Hpmisj3OPE/Wzn9LAXwBnkging
         xKg4gBBjmT5OuVtUafrX35ta3d9zR1R4zw/4yXZ7VS+VHZ0z3J1IEFeKsfqjlOKnx0WQ
         kfMAgZz9fJPEek5kP4KioxPumHwQhg9YVJ2I9H8DB9w4QkqX6Pr+uagUKxCjunIHz+1M
         FoGAoDzspe44XNwcU+prI/QqOiQetV39TIPMWpJSfvebZRanA681XXaJ1u/LiTWrXfil
         SQdw==
MIME-Version: 1.0
X-Received: by 10.52.77.38 with SMTP id p6mr2133479vdw.60.1386266290327; Thu,
 05 Dec 2013 09:58:10 -0800 (PST)
Received: by 10.58.116.133 with HTTP; Thu, 5 Dec 2013 09:58:10 -0800 (PST)
Date: Thu, 5 Dec 2013 21:58:10 +0400
Message-ID: 
 <CAB9JMRd7U2z5kmRpD9V77ExhFPQWOt9L1ZJ6t4=YXV8BdbhO9Q@mail.gmail.com>
Subject: how to find nodes by row key?
From: Daneel Yaitskov <rtfm.rtfm.rtfm@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=20cf307f383cccc2cf04eccd4572
X-Virus-Checked: Checked by ClamAV on apache.org

--20cf307f383cccc2cf04eccd4572
Content-Type: text/plain; charset=UTF-8

Hi,

I study cassandra and want to play with it.
I need to shrink the number of
available row instances.

Next send a search request for it in cqlsh with different consistency
levels.
To observe behavior I need to know which instance to take down.


I found cassandra-cli command list.

this command works
$ list ticks  limit 4;

but next doesn't
$ list ticks[1:'FEURUS':'c'];
list ticks[1:'FEURUS':'c'];
Syntax error at position 21: mismatched input ':' expecting ']'

As you see there is a composite key consisting of 3 columns.

I can use assume command to change key view.
But none of them are looks similar to values in the token column of
nodetool ring  command.

The best solution would be get IP address (node UUID) directly by a human
readable structured  row key.


My cassandra cluster has version 2.0.3.
-- 
Daneel S. Yaitskov

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

<div dir=3D"ltr"><div>Hi,<br><br></div><div>I study cassandra and want to p=
lay with it.<br></div><div>I need to shrink the number of<br></div><div>ava=
ilable row instances.<br><br></div><div>Next send a search request for it i=
n cqlsh with different consistency levels.<br>
</div><div>To observe behavior I need to know which instance to take down.<=
br><br></div><div><br></div><div></div><div>I found cassandra-cli command l=
ist.<br><br>this command works<br></div><div>$ list ticks=C2=A0 limit 4;<br=
>
<br></div><div>but next doesn&#39;t<br></div><div>$ list ticks[1:&#39;FEURU=
S&#39;:&#39;c&#39;];<br>list ticks[1:&#39;FEURUS&#39;:&#39;c&#39;];<br>Synt=
ax error at position 21: mismatched input &#39;:&#39; expecting &#39;]&#39;=
<br>
<br></div><div>As you see there is a composite key consisting of 3 columns.=
 <br><br></div><div>I can use assume command to change key view.<br></div><=
div>But none of them are looks similar to values in the token column of nod=
etool ring=C2=A0 command.<br>
<br></div><div>The best solution would be get IP address (node UUID) direct=
ly by a human readable structured=C2=A0 row key.<br></div><div><br></div><d=
iv><br></div><div>My cassandra cluster has version 2.0.3.<br clear=3D"all">=
</div>
<div>-- <br>Daneel S. Yaitskov<br>
</div></div>

--20cf307f383cccc2cf04eccd4572--