Return-Path: Delivered-To: apmail-hadoop-hbase-user-archive@minotaur.apache.org Received: (qmail 32936 invoked from network); 12 Nov 2009 19:46:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 12 Nov 2009 19:46:16 -0000 Received: (qmail 49804 invoked by uid 500); 12 Nov 2009 19:46:15 -0000 Delivered-To: apmail-hadoop-hbase-user-archive@hadoop.apache.org Received: (qmail 49775 invoked by uid 500); 12 Nov 2009 19:46:15 -0000 Mailing-List: contact hbase-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hbase-user@hadoop.apache.org Delivered-To: mailing list hbase-user@hadoop.apache.org Received: (qmail 49765 invoked by uid 99); 12 Nov 2009 19:46:15 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Nov 2009 19:46:15 +0000 X-ASF-Spam-Status: No, hits=-2.4 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of saint.ack@gmail.com designates 209.85.221.188 as permitted sender) Received: from [209.85.221.188] (HELO mail-qy0-f188.google.com) (209.85.221.188) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Nov 2009 19:46:13 +0000 Received: by qyk26 with SMTP id 26so1183503qyk.5 for ; Thu, 12 Nov 2009 11:45:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:in-reply-to :references:date:x-google-sender-auth:message-id:subject:from:to :content-type; bh=kNi22dWBfvlmxPYFgeIJ9p/WsmJurrrIjB9nj14tnvs=; b=Iit7wvIyP9gwN7VBfeqGRxr6Bc5Qonxa0pq/GndfAWFAzkxWKkr3hcacJl3H7bOtcF cnozjPViRlK/uFOD2vnM4yymA8xa9Jdjz0D23gpAyOFdBTeKtU9Z/XHBeSXpwf9NJhoW 4OwggRMwR8xsmHlymTrB1eo3WeEnG2wLs1gDQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:content-type; b=AF0PJZzXCPkHzp3y7LKNZoHMt4L2QSDQC6AfipojB0QdBVxthB4aI2Konm5R8Y2evp 4JaqVO8x8Yy2fYRWdAbJmAHTqaJNnbLsH+jEffBaMy7HUWR068o0f0bQzsYIdp/ZKM4v ICag8VktEME9p0Hc38TPBogGmHCfOESH9U9DU= MIME-Version: 1.0 Sender: saint.ack@gmail.com Received: by 10.229.23.74 with SMTP id q10mr464236qcb.63.1258055152619; Thu, 12 Nov 2009 11:45:52 -0800 (PST) In-Reply-To: References: <4AFA9EEF.201@gmail.com> <31a243e70911110902r6b6ac67en71cdfcdb0bd0e87c@mail.gmail.com> <4AFB29D1.7030501@gmail.com> <8211a1320911112145g580d60f2j8c90007cb83a077a@mail.gmail.com> <78568af10911112217v692a2251vf9be0a20096e2ebe@mail.gmail.com> Date: Thu, 12 Nov 2009 11:45:52 -0800 X-Google-Sender-Auth: 40d53759e32e8bce Message-ID: <7c962aed0911121145q6745076ao10ec5bd5f4b102e1@mail.gmail.com> Subject: Re: newbie question: what is better? one with a lot of keys OR a lot of tables with fewer keys? From: stack To: hbase-user@hadoop.apache.org Content-Type: multipart/alternative; boundary=0016367f94da7ad170047831ca45 --0016367f94da7ad170047831ca45 Content-Type: text/plain; charset=ISO-8859-1 On Wed, Nov 11, 2009 at 10:25 PM, Greg Cottman wrote: > Hi Ryan, > > If you only query columns from one column family though, won't HBase use > data locality to fetch only enough data to populate that column family? > > That way you can have rows with more columns in them, and still write > efficient queries that don't fetch all the irrelevant columns in a fat row. > > Yes. St.Ack --0016367f94da7ad170047831ca45--