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 8C660DC49 for ; Mon, 23 Jul 2012 17:49:32 +0000 (UTC) Received: (qmail 61640 invoked by uid 500); 23 Jul 2012 17:49:29 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 61623 invoked by uid 500); 23 Jul 2012 17:49:29 -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 61615 invoked by uid 99); 23 Jul 2012 17:49:29 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jul 2012 17:49:29 +0000 X-ASF-Spam-Status: No, hits=1.8 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,PLING_QUERY,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of mohitanchlia@gmail.com designates 209.85.213.44 as permitted sender) Received: from [209.85.213.44] (HELO mail-yw0-f44.google.com) (209.85.213.44) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jul 2012 17:49:22 +0000 Received: by yhq56 with SMTP id 56so6293091yhq.31 for ; Mon, 23 Jul 2012 10:49:01 -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=6GZdlS7hzQ7Ekt4r6w9NozTDDEvLDzDyxtzEWXLjdbE=; b=v4fBHvZ8p0iviLHa4ntqkjPmqLUcQAbECBNUn2uIeCiGyIdjXkOeK3boUbqQadn/fi INF+7e2aarws52mlwcEuePnAWaWQPZp5FDNtfW/GgaNis57zx73BE99I8SnHWXMtnGSf 6ttxJ8bfOo1lnmYqstzoYDmkjcbS09bC2OLh2RrTaO4xZe6oyFbb4Cas2hXKYUt/Gig2 yTb4L+PZsbI0Egm8QJysyEypYrcRMdxuIr/+6bF9LFNXphE//23ltqvLcYo0hvWCSxnV f02V73GZGZ/EvUmWTmvl1hl8ctdvsf7lxAy2pYl78Nt67OHw8L64+ZMteNqMSan23pcS R7eA== MIME-Version: 1.0 Received: by 10.50.36.137 with SMTP id q9mr8021035igj.14.1343065741042; Mon, 23 Jul 2012 10:49:01 -0700 (PDT) Received: by 10.64.65.1 with HTTP; Mon, 23 Jul 2012 10:49:00 -0700 (PDT) In-Reply-To: References: Date: Mon, 23 Jul 2012 10:49:00 -0700 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: Mohit Anchlia To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=14dae9340de567a4b104c582dc53 --14dae9340de567a4b104c582dc53 Content-Type: text/plain; charset=ISO-8859-1 On Mon, Jul 23, 2012 at 10:07 AM, Ertio Lew wrote: > My major concern is that is it too bad retrieving 300-500 rows (each for a > single column) in a single read query that I should store all these(around > a hundred million) columns in a single row? You could create multiple rows and each row with around 1k-2k columns depending on how big your columns are. I definitely suggest running some tests? Is this timeseries data or event type data? --14dae9340de567a4b104c582dc53 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
On Mon, Jul 23, 2012 at 10:07 AM, Ertio Lew <e= rtiop93@gmail.com> wrote:
My major concern is that is it too ba= d retrieving 300-500 rows (each for a single column) in a single read query= that I should store all these(around a hundred million) columns in a singl= e row? =A0
=A0
You could create multiple rows and each row with around 1k-2k columns = depending on how big your columns are. I definitely suggest running some te= sts? Is this timeseries data or event type data?
--14dae9340de567a4b104c582dc53--