Return-Path: 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 CFE444FDA for ; Thu, 19 May 2011 16:39:15 +0000 (UTC) Received: (qmail 21713 invoked by uid 500); 19 May 2011 16:39:13 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 21686 invoked by uid 500); 19 May 2011 16:39:13 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 21662 invoked by uid 99); 19 May 2011 16:39:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 May 2011 16:39:13 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,MIME_QP_LONG_LINE,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of watanabe.maki@gmail.com designates 209.85.212.175 as permitted sender) Received: from [209.85.212.175] (HELO mail-px0-f175.google.com) (209.85.212.175) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 May 2011 16:39:07 +0000 Received: by pxi17 with SMTP id 17so1997686pxi.34 for ; Thu, 19 May 2011 09:38:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:subject:references:from:content-type:x-mailer :in-reply-to:message-id:date:to:content-transfer-encoding :mime-version; bh=LTb+VL458xgnGR+nyxJgqWfsaHKaFALfTh73ypFPa68=; b=NEnm+oTgP/XmVkUi6sjtJy67pB05KFyiZW6RvK9Sye9US9+9x9jBl/NUvHNUPSEVRV rzXfKhPYKaUNyFFzdYNGbc+lF6a0fmOVWquOja+M9C5fbIxe9NBeohjDsD8NvUd90PxT OBUqL8GgayPilHIQna5Tp0gTSdcloUecAQ4R0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:references:from:content-type:x-mailer:in-reply-to :message-id:date:to:content-transfer-encoding:mime-version; b=DF1o0iibMkzKpKzuZC+HtUaBgcbKCAv2QFFOWLGeyyJ0G4MndIwc7h0ga91St7dgth hCeMEsfwX5nikb+vAW96rNj2Y0pLceTrbQnpJ3lVSZaiCnYmUkUJYGEGKCuWh7zLtvP7 KO9WFCWOaAOQVtITEdBh0vDJ7ESRNWR0OtO4Q= Received: by 10.68.40.164 with SMTP id y4mr5377046pbk.291.1305823127104; Thu, 19 May 2011 09:38:47 -0700 (PDT) Received: from [192.168.10.232] (s31.TF24.vectant.ne.jp [183.177.162.31]) by mx.google.com with ESMTPS id m4sm1844470pbb.78.2011.05.19.09.38.44 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 19 May 2011 09:38:45 -0700 (PDT) Subject: Re: selecting data References: <126398.71778.qm@web28609.mail.ukl.yahoo.com> From: Watanabe Maki Content-Type: multipart/alternative; boundary=Apple-Mail-37--1049074164 X-Mailer: iPhone Mail (8G4) In-Reply-To: <126398.71778.qm@web28609.mail.ukl.yahoo.com> Message-Id: Date: Fri, 20 May 2011 01:38:39 +0900 To: "user@cassandra.apache.org" Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (iPhone Mail 8G4) --Apple-Mail-37--1049074164 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Cassandra is not a RDBMS. Only you can do is search on a key, or you need fu= ll scan. You need to design your schema carefully as your application needs. On 2011/05/20, at 1:11, karim abbouh wrote: > i'm new using cassandra database, > i want to get data as in relationnel database: > select * from table where field=3D"value"; > i see using CLI we have just the followings commands : > get .[''] Get a slice of co= lumns. > get .[''][''] Get a slice of sub co= lumns. > get .[''][''] Get a column v= alue. > get .[''][''][''] Get a sub column v= alue. >=20 > is there a way for that. > i think using java API is possible. > cassandra version : 6.0.12 >=20 >=20 > thanks for help >=20 >=20 >=20 --Apple-Mail-37--1049074164 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
Cassandra is not a RDBMS. Only you can d= o is search on a key, or you need full scan.
You need to design yo= ur schema carefully as your application needs.

=
On 2011/05/20, at 1:11, karim abbouh <karim_rbt@yahoo.fr> wrote:

i'm new using cassandra database,
i want to g= et data as in relationnel database:
select * from table where field=3D"va= lue";
i see using CLI we have just the followings commands :
get <k= sp>.<cf>['<key>']       &n= bsp;            =             &nbs= p; Get a slice of columns.
get <ksp>.<cf>['<key>']['<= ;super>']          &nbs= p;        Get a slice of sub columns.
= get <ksp>.<cf>['<key>']['<col>']    = ;            &nb= sp;            Get a c= olumn value.
get <ksp>.<cf>['<key>']['<super>']['= <col>']          &nb= sp;   Get a sub column value.

is there a way for that.
i= think using java API is possible.
cassandra version : 6.0.12


= thanks for help



= --Apple-Mail-37--1049074164--