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 A0EB99D6C for ; Mon, 26 Mar 2012 21:16:57 +0000 (UTC) Received: (qmail 29163 invoked by uid 500); 26 Mar 2012 21:16:55 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 29141 invoked by uid 500); 26 Mar 2012 21:16:55 -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 29129 invoked by uid 99); 26 Mar 2012 21:16:55 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Mar 2012 21:16:55 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of ertiop93@gmail.com designates 209.85.160.44 as permitted sender) Received: from [209.85.160.44] (HELO mail-pb0-f44.google.com) (209.85.160.44) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Mar 2012 21:16:46 +0000 Received: by pbbrq13 with SMTP id rq13so6719174pbb.31 for ; Mon, 26 Mar 2012 14:16:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=h5HFzWZT6FC87HPug8oy8Gz2+rvJfPKMwSHCe/KehlM=; b=IAEIKdr+pHisFgF7upBQCdjjy7bQQ/C3DWSA5HKFBkkpQI50xKsexd2zFc4g7g/Sp8 jT+LGUPDwbrkxIy927RhuuCyh5gRDwU/RXrl88zZf6dduc0bbk2c8iTDkXncoMDhM6Nt EvhYaDP5VJZtH70Ofxv9VnIj+1ylSB+4wx9jFc1PSbyPOkxoHc2l3L+kYDFNA0zY/+Ow VxbOOZvCS4rhJI8+WKNaystsjgyVXc1lJhSusm6Qt/xfKMBxwM/3U0aQmXXwg1hIv4/d DnMYeJsvRb9bIOKokoWUcru/03oJaS+nbXjujFMxFL7kT/NmSyYDBp0Bq4sN+vvGci+k q4Ew== MIME-Version: 1.0 Received: by 10.68.221.40 with SMTP id qb8mr56241459pbc.154.1332796585788; Mon, 26 Mar 2012 14:16:25 -0700 (PDT) Received: by 10.68.239.100 with HTTP; Mon, 26 Mar 2012 14:16:25 -0700 (PDT) Date: Tue, 27 Mar 2012 02:46:25 +0530 Message-ID: Subject: Schema advice/help From: Ertio Lew To: user Content-Type: multipart/alternative; boundary=e89a8ff256a20dc5aa04bc2be366 X-Virus-Checked: Checked by ClamAV on apache.org --e89a8ff256a20dc5aa04bc2be366 Content-Type: text/plain; charset=ISO-8859-1 I need to store activities by each user, on 5 items types. I always want to read last 10 activities on each item type, by a user (ie, total activities to read at a time =50). I am wanting to store these activities in a single row for each user so that they can be retrieved in single row query, since I want to read all the last 10 activities on each item.. I am thinking of creating composite names appending "itemtype" : "activityId"(activityId is just timestamp value) but then, I don't see about how to read the last 10 activities from all itemtypes. Any ideas about schema to do this better way ? --e89a8ff256a20dc5aa04bc2be366 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I need to store activities by each user, on 5 items=A0types. I always want = to read last 10 activities on each item type, by a user (ie, total activiti= es to read at a time =3D50).

I am wanting to store these= activities in a single row for each user so that they can be retrieved in = single row query, since I want to read all the last 10 activities on each i= tem.. I am thinking of creating composite names appending "itemtype&qu= ot; : "activityId"(activityId is just timestamp value) but then, = I don't see about how to read the last 10 activities from all itemtypes= .

Any ideas about schema to do this better way ?
--e89a8ff256a20dc5aa04bc2be366--