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 35537DD0C for ; Mon, 23 Jul 2012 18:17:21 +0000 (UTC) Received: (qmail 53819 invoked by uid 500); 23 Jul 2012 18:17:18 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 53796 invoked by uid 500); 23 Jul 2012 18:17:18 -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 53788 invoked by uid 99); 23 Jul 2012 18:17:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jul 2012 18:17:18 +0000 X-ASF-Spam-Status: No, hits=2.0 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FSL_RCVD_USER,HTML_MESSAGE,PLING_QUERY,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, 23 Jul 2012 18:17:12 +0000 Received: by pbcwy7 with SMTP id wy7so11601822pbc.31 for ; Mon, 23 Jul 2012 11:16:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=5AyZvzF4Zw56mF1Qvgzk8YrSyCi5ACvqKqci8t2ha50=; b=xcImXGekXT5sTm5lqqtc7uzc8alQZT7ix6i38ufLlk9r85+Q6ybbKolLAB6iwjbTqB YB5gEUUJsDxqg7sw3sX1u7i6f0XEH0QBHRMEY/bCU+nzUyPhHhm63pf98Eb1NDVYfERO T++DXeUa8lfknWPpe2a/bI/8kBvElxDo5Ikbsfd9r3EJaZrIpllOT4g9IWHQk4XB1578 5rpYqvYtuxGPBYcvlowIegZkBTEWPxj8gMUMCVa84Ssf9YWXAfkArlw6mclUI9s6jvv5 L417TofoP86GWnW/lVdDJHQaUL0N4TtFVLQWlN8LtYNodNhfQKPPdyVXuJfm3LfMSYdX RDGQ== MIME-Version: 1.0 Received: by 10.68.228.102 with SMTP id sh6mr37561709pbc.134.1343067411363; Mon, 23 Jul 2012 11:16:51 -0700 (PDT) Received: by 10.68.194.99 with HTTP; Mon, 23 Jul 2012 11:16:51 -0700 (PDT) In-Reply-To: References: Date: Mon, 23 Jul 2012 23:46:51 +0530 Message-ID: Subject: Re: Schema advice: (Single row or multiple row!?) How do I store millions of columns when I need to read a set of around 500 columns at a single read query using column names ? From: Ertio Lew To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=e89a8ff2447bf6b7ce04c5833f40 X-Virus-Checked: Checked by ClamAV on apache.org --e89a8ff2447bf6b7ce04c5833f40 Content-Type: text/plain; charset=ISO-8859-1 I want to read columns for a randomly selected list of userIds(completely random). I fetch the data using userIds(which would be used as column names in case of single row or as rowkeys incase of 1 row for each user) for a selected list of users. Assume that the application knows the list of userIds which it has to demand from DB. --e89a8ff2447bf6b7ce04c5833f40 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I want to read columns=A0for a=A0randomly selected list of userIds(complete= ly random). I fetch the data using userIds(which would be used as column na= mes in case of single row or as rowkeys incase of 1 row for each user) for = a selected list of users. Assume that the application knows the list of use= rIds =A0which it has to demand from DB. --e89a8ff2447bf6b7ce04c5833f40--