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 05319D4A5 for ; Wed, 26 Sep 2012 21:52:53 +0000 (UTC) Received: (qmail 51578 invoked by uid 500); 26 Sep 2012 21:52:50 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 51549 invoked by uid 500); 26 Sep 2012 21:52:50 -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 51540 invoked by uid 99); 26 Sep 2012 21:52:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Sep 2012 21:52:50 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of infalco@gmail.com designates 209.85.212.172 as permitted sender) Received: from [209.85.212.172] (HELO mail-wi0-f172.google.com) (209.85.212.172) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Sep 2012 21:52:44 +0000 Received: by wibhq12 with SMTP id hq12so3928379wib.7 for ; Wed, 26 Sep 2012 14:52:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=KaMM1hbdtDleOi7AYFJVgMMkX4ML6I4hIeYIZIpmvMY=; b=p1WhaLxZDoq6xHh3JTWYadi16qm5VNLzSUxmM2AzwIxadiMH682n2ARq7In7n/P83s lDhAEBW8PPMoaEFm7cVhRp7otvxT/io4xoRiG4BqhStAdeXNNQYND7OwlbFZIJzJdONO nJj9eOSW3y+SvKS9kxst+iRrQb8OAYNHMWmTk5Quf2ghXYBOdKU2F1cvtRPYqyEnv1BT CQ2S1aXaoH2urU6ZPtsFdlcK+E8w9aqB36mEDMBrnA58BVciaVSsZBFCtftad5lFLUFB 9+ACI6q9Lx0cqxQ7KWNRC7XBPxFY83n7I4ODZjKMqZj0EPy/ksHn/QqZKLJ22iAXsZ8q hcyg== Received: by 10.216.45.144 with SMTP id p16mr301409web.170.1348696342622; Wed, 26 Sep 2012 14:52:22 -0700 (PDT) MIME-Version: 1.0 Received: by 10.227.58.81 with HTTP; Wed, 26 Sep 2012 14:52:02 -0700 (PDT) From: Edward Kibardin Date: Wed, 26 Sep 2012 22:52:02 +0100 Message-ID: Subject: Once again, super columns or composites? To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=0016e6dbdf496972d004caa1d6d1 X-Virus-Checked: Checked by ClamAV on apache.org --0016e6dbdf496972d004caa1d6d1 Content-Type: text/plain; charset=ISO-8859-1 Hi Community, I know, I know... every one is claiming Super Columns are not good enough and it dangerous to use them now. But from my perspective, they have several very good advantages like: 1. You are not fixed schema and always can add one more columns to subset of your supercolumns 2. SuperColumn is loaded as whole if you requesting for at least one sub column, but it's the same as loading a whole composite value to get only one sub-value 3. In supercolumns you can update only one subcolumn without touching other subcolumns, in case of composites you're unable to update just a portion of composite value. May be I do not understand composites correctly, but having very small supercolumns (10-15 subcolumns) I still think SuperColumns might be the best solution for me... In addition, building supercolumns with SSTableWriter is pretty much strait-forward for me, while it's not the case with composites... Any arguments? --0016e6dbdf496972d004caa1d6d1 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi Community,

I know, I know... every one is claiming Su= per Columns are not good enough and it dangerous to use them now.
But from my perspective, they have several very good advantages like:
  1. You are not fixed schema and always can add one more columns t= o subset of your supercolumns
  2. SuperColumn is loaded as whole if you= requesting for at least one sub column, but it's the same as loading a= whole composite value to get only one sub-value
  3. In supercolumns you can update only one subcolumn without touching othe= r subcolumns, in case of composites you're unable to update just a port= ion of composite value.
May be I do not understand composites= correctly, but having very small supercolumns (10-15 subcolumns) I still t= hink SuperColumns might be the best solution for me...
In addition, building=A0supercolumns with SSTableWriter is prett= y much=A0strait-forward=A0for me, while it's not the case with composit= es...

Any arguments?


=
--0016e6dbdf496972d004caa1d6d1--