Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 53856 invoked from network); 29 Apr 2010 21:28:33 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 29 Apr 2010 21:28:33 -0000 Received: (qmail 80213 invoked by uid 500); 29 Apr 2010 21:28:32 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 80196 invoked by uid 500); 29 Apr 2010 21:28:31 -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 80188 invoked by uid 99); 29 Apr 2010 21:28:31 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Apr 2010 21:28:31 +0000 X-ASF-Spam-Status: No, hits=-0.2 required=10.0 tests=AWL,FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of jbellis@gmail.com designates 74.125.82.172 as permitted sender) Received: from [74.125.82.172] (HELO mail-wy0-f172.google.com) (74.125.82.172) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Apr 2010 21:28:26 +0000 Received: by wyb35 with SMTP id 35so5710017wyb.31 for ; Thu, 29 Apr 2010 14:28:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:received:in-reply-to :references:from:date:message-id:subject:to:content-type :content-transfer-encoding; bh=N0BHLrP8fZAYOC6oSGAeA3n9/L3CClSfnoJT/6p1+AE=; b=xHqDAp+aCrXnT4l74//QCQWJKev/XfCR8tSCDlR3wy2yGtU/Ol18z9Tbm4hZuOyXSV HuGzn9jNUb2kNuvvwQgyUaEcigWDH4bAIFsUGoP72BXT/S+AuElPhImoQIJ66AKh+g7j kDFfDGoGJsHJjH9tBWp5PWz5Ay5WTu1eNe+iE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:content-transfer-encoding; b=XCaVzm0c+pVZ8dhUw0iO4GIREfvCYPagjvZJxATmkUvJj7F9iqJzJwxrH19V1klM9y XK3VnXVGlym+ydTEihIndojMzM5F2N3eMq2mxeJex6VQThFL7rLEDgY8anm/92hLZhKD V9nnCzQoUa/5zkivXUdkMtK+sDaadE8t1OPYE= Received: by 10.216.90.208 with SMTP id e58mr5280053wef.57.1272576417508; Thu, 29 Apr 2010 14:26:57 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.22.10 with HTTP; Thu, 29 Apr 2010 14:26:36 -0700 (PDT) In-Reply-To: References: From: Jonathan Ellis Date: Thu, 29 Apr 2010 16:26:36 -0500 Message-ID: Subject: Re: can we have duplicate keys ? To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable use dynamic column names. make a CF called Articles, have row key =3D 12, first column name 123, next column name 124, etc. On Thu, Apr 29, 2010 at 4:40 AM, vineet daniel wro= te: > Hi > > Can anyone please tell me if we can have duplicate keys in Super Column > Family, if now how can we represent this : - > > Article and Category Mapping > > =A0clientOne.insert(:ArticleCategory, "12", {"ArticleID" =3D> "123"}) > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=A0 =A0=A0=A0 =A0= =A0=A0 =A0=A0=A0 =A0=A0=A0 =A0=A0=A0=A0 "12", {"ArticleID" =3D> > "124"}) > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=A0 =A0 "12", {"Arti= cleID" =3D> > "125"}) > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=A0 "12", {"Article= ID" =3D> > "126"}) > > Here 12 is they key for a Category name 'sample' and all the four article= s > are part of this key or sample. Is this right or I need to do something e= lse > ? > > > --=20 Jonathan Ellis Project Chair, Apache Cassandra co-founder of Riptano, the source for professional Cassandra support http://riptano.com