Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 85761 invoked from network); 13 Mar 2010 01:51:42 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 13 Mar 2010 01:51:42 -0000 Received: (qmail 35636 invoked by uid 500); 13 Mar 2010 01:51:03 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 35611 invoked by uid 500); 13 Mar 2010 01:51:03 -0000 Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cassandra-user@incubator.apache.org Delivered-To: mailing list cassandra-user@incubator.apache.org Received: (qmail 35603 invoked by uid 99); 13 Mar 2010 01:51:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 13 Mar 2010 01:51:03 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of driftx@gmail.com designates 209.85.221.177 as permitted sender) Received: from [209.85.221.177] (HELO mail-qy0-f177.google.com) (209.85.221.177) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 13 Mar 2010 01:50:55 +0000 Received: by qyk7 with SMTP id 7so1753211qyk.21 for ; Fri, 12 Mar 2010 17:50:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=eM93mre5MlMUr8ZHcFCH0TKpqdmUxWMTTHgV2gEH88A=; b=H+1wWqF/3xbonhNF9FTIp7RIytvue206qhxBJ2+pyir/lVUEA9xYTS5TPSBELTt3xI /obkGKVT4DLLved0P4LkCN9xxsCrAZwrUSIJUWsz0IfYoOJWQ3q/N/FxklUfzXhZk7dd J0bymr6McedM4cLvkB0l00/fsYYDRSbzA3Wxo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=sQ0rQ+bWNl4yK+a6h2yFVzOyT5PKGu7ftnK/f8MYAgIlyXDTRGuEmO0kXzsQKlwGox eYqxKmo/01wqDX5jm4fTJZ5U1j44e682p9KIwhR+W+9k3othiZ8idb8PjvAIZdNrhoh2 samIspY+2uejYjtKgy2jO/qtx7ItR5N9HAH8A= MIME-Version: 1.0 Received: by 10.220.116.129 with SMTP id m1mr1564984vcq.7.1268445034878; Fri, 12 Mar 2010 17:50:34 -0800 (PST) In-Reply-To: <458b8f9e1003121746n72a130a9gdfda466867dc33e8@mail.gmail.com> References: <458b8f9e1003102254gae3eab9p4bacde04c797a5f4@mail.gmail.com> <458b8f9e1003121707u224877ddh10b49c041e41aeb8@mail.gmail.com> <458b8f9e1003121721j4a70a244pdb51aee399edf5af@mail.gmail.com> <458b8f9e1003121746n72a130a9gdfda466867dc33e8@mail.gmail.com> Date: Fri, 12 Mar 2010 19:50:34 -0600 Message-ID: Subject: Re: Strategies for storing lexically ordered data in supercolumns From: Brandon Williams To: cassandra-user@incubator.apache.org Content-Type: multipart/alternative; boundary=001485e772b8b895950481a4dfd4 X-Virus-Checked: Checked by ClamAV on apache.org --001485e772b8b895950481a4dfd4 Content-Type: text/plain; charset=ISO-8859-1 On Fri, Mar 12, 2010 at 7:46 PM, Peter Chang wrote: > Yes, I can update that one entry. But what if that subcolumn key is used > across many different places? > > ['Jones-Bob']['connections'] > ['Hacker-Alyssa-1ab54760-2ca8-11df-aabd-005056c00001'] > ['Crabtree-Sam']['connections'] > ['Hacker-Alyssa-1ab54760-2ca8-11df-aabd-005056c00001'] > ['Rice-Brown']['connections'] > ['Hacker-Alyssa-1ab54760-2ca8-11df-aabd-005056c00001'] > ... > > I can update every single entry but now I need to keep track of them (which > I guess I'm doing anyway). I was wondering if there was a more elegant > solution but it seems unlikely based on the given constraints. > You have to update them all and track them, correct. What you're looking for sounds like transaction support, which Cassandra does not have. On the bright side, writes are cheap. -Brandon --001485e772b8b895950481a4dfd4 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
On Fri, Mar 12, 2010 at 7:46 PM, Peter Chang <peter78@gmail.com> wrote:
Yes, I can update that one entry. But what if that subcolumn key is used ac= ross many different places?

['Jones-Bob']['c= onnections']['Hacker-Alyssa-1ab54760-2ca8-11df-aabd-0050= 56c00001']
['Crabtree-Sam']['connections']['Hacker= -Alyssa-1ab54760-2ca8-11df-aabd-005056c00001']
['Rice-Brown']['connections']['Hacker-Alyssa= -1ab54760-2ca8-11df-aabd-005056c00001']
...

I can update every single entry but now I need to = keep track of them (which I guess I'm doing anyway). I was wondering if= there was a more elegant solution but it seems unlikely based on the given= constraints.


-Brandon=A0
--001485e772b8b895950481a4dfd4--