Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 21971 invoked from network); 16 May 2010 22:08:15 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 16 May 2010 22:08:15 -0000 Received: (qmail 20814 invoked by uid 500); 16 May 2010 22:08:14 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 20795 invoked by uid 500); 16 May 2010 22:08:14 -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 20787 invoked by uid 99); 16 May 2010 22:08:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 16 May 2010 22:08:13 +0000 X-ASF-Spam-Status: No, hits=0.2 required=10.0 tests=AWL,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [209.85.221.193] (HELO mail-qy0-f193.google.com) (209.85.221.193) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 16 May 2010 22:08:09 +0000 Received: by qyk31 with SMTP id 31so6738997qyk.25 for ; Sun, 16 May 2010 15:07:48 -0700 (PDT) MIME-Version: 1.0 Received: by 10.229.211.208 with SMTP id gp16mr4662qcb.117.1274047667895; Sun, 16 May 2010 15:07:47 -0700 (PDT) Received: by 10.229.229.133 with HTTP; Sun, 16 May 2010 15:07:47 -0700 (PDT) In-Reply-To: <24623_1273593091_4BE97D03_24623_1727_1_76021AEC9BA668409BB1AFBFBF945BE66661C99DD7@PMEXCB1B.intranet-paris.francetelecom.fr> References: <24623_1273593091_4BE97D03_24623_1727_1_76021AEC9BA668409BB1AFBFBF945BE66661C99DD7@PMEXCB1B.intranet-paris.francetelecom.fr> Date: Sun, 16 May 2010 15:07:47 -0700 Message-ID: Subject: Re: Nodes Levels of Hierarchy in Cassandra. From: Benjamin Black To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Not in Cassandra. Your description of the levels is not quite accurate, either. The keyspaces and CFs are generally considered fixed since it is rather expensive to change them compared to the row keys and columns. Within an SCF, you have: row_key: {supercolumn1: {column1A: value1A, column1B: value1B}, supercolumn2: {column2A: value2A, column2B: value2B}} So the 3 levels of the hierarchy with SCFs are row key->supercolumn->column. You can certainly treat the SCF itself as a 4th level of the hierarchy if you like, but don't expect to add and remove them as you do the 3 'dynamic' levels. b On Tue, May 11, 2010 at 8:51 AM, wrote: > Hi. > > =A0 I undertstood I can use this structure with cassandra : > > KeySpace_3nodeslevels =3D { > =A0=A0=A0 Key_Family_alfa : { > =A0=A0=A0=A0=A0=A0=A0 Key_Super_Column_A : { Key_Column_1: "Value_alfa_A_= 1", > =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 Key_Column_2: "Value_alfa_A_2"}, > =A0=A0=A0=A0=A0=A0=A0 Key_Super_Column_B : { Key_Column_1: "Value_alfa_B_= 1", > =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 Key_Column_2: "Value_alfa_B_2"} }, > =A0=A0=A0 Key_Family_beta : { > =A0=A0=A0=A0=A0=A0=A0 Key_Super_Column_A : { Key_Column_1: "Value_beta_A_= 1", > =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 Key_Column_2: "Value_beta_A_2"}, > =A0=A0=A0=A0=A0=A0=A0 Key_Super_Column_B : { Key_Column_1: "Value_beta_B_= 1", > =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 Key_Column_2: "Value_beta_B_2"} } > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 } > > I have 3 nodes levels of hierarchy for the keys : Key_Family, > Key_Super_Column and=A0=A0Key_Column. > I have around 100 Billions of keys for the Family level. > > =A0 Can I have 4 nodes levels of hierarchy like this ? > > KeySpace_4nodeslevels =3D { > =A0=A0=A0 Key_level1_alfa : { > =A0=A0=A0=A0=A0=A0=A0 Key_level2_A : { Key_level3_1: { Key_level4_first= =A0 : > "Value_alfa_A_1_first", > =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 Key_level4_Second : > "Value_alfa_A_1_second"}, > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = Key_level3_2: { Key_level4_first=A0 : > "Value_alfa_A_2_first", > =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 Key_level4_Second : > "Value_alfa_A_2_second"} }, > =A0=A0=A0=A0=A0=A0=A0 Key_level2_B : { Key_level3_1: { Key_level4_first= =A0 : > "Value_alfa_B_1_first", > =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 Key_level4_Second : > "Value_alfa_B_1_second"}, > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = Key_level3_2: { Key_level4_first=A0 : > "Value_alfa_B_2_first", > =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 Key_level4_Second : > "Value_alfa_B_2_second"} } }, > =A0=A0=A0 Key_level1_beta : { > =A0=A0=A0=A0=A0=A0=A0 Key_level2_A : { Key_level3_1: { Key_level4_first= =A0 : > "Value_beta_A_1_first", > =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 Key_level4_Second : > "Value_beta_A_1_second"}, > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = Key_level3_2: { Key_level4_first=A0 : > "Value_beta_A_2_first", > =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 Key_level4_Second : > "Value_beta_A_2_second"} }, > =A0=A0=A0=A0=A0=A0=A0 Key_level2_B : { Key_level3_1: { Key_level4_first= =A0 : > "Value_beta_B_1_first", > =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 Key_level4_Second : > "Value_beta_B_1_second"}, > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = Key_level3_2: { Key_level4_first=A0 : > "Value_beta_B_2_first", > =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 Key_level4_Second : > "Value_beta_B_2_second"} } } > =A0=A0 =A0=A0=A0=A0 } > > Thanks. > > ********************************* > This message and any attachments (the "message") are confidential and > intended solely for the addressees. > Any unauthorised use or dissemination is prohibited. > Messages are susceptible to alteration. > France Telecom Group shall not be liable for the message if altered, chan= ged > or falsified. > If you are not the intended addressee of this message, please cancel it > immediately and inform the sender. > ******************************** >