Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of bernd.fondermann@googlemail.com
 designates 209.85.214.41 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=m9O18e4flx/ETFyq8PSQEedskEHgYhDknbfPNbmhMrSMHhufflgSPLBc4hSjBvKQ0l
         T69EfoPYR8/4kj2fkABvtHoN3qReDKkS6pVppmsiONXKAZIQikpVvhgPaPpXdN5NQ7IA
         XWcgmEnx/FXzfHZQHfIN82YGjTWhQc0wjE780=
MIME-Version: 1.0
In-Reply-To: <loom.20110423T095438-759@post.gmane.org>
References: <loom.20110423T095438-759@post.gmane.org>
Date: Sat, 23 Apr 2011 11:25:47 +0200
Message-ID: <BANLkTiny9Uk4ADZ+CojMPAh_gAf3iaU2BQ@mail.gmail.com>
Subject: Re: HBase - Column family
From: Bernd Fondermann <bernd.fondermann@googlemail.com>
To: user@hbase.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

That's how I would do it:
What's nice in HBase is that you can store all the data for one of
your keywords in a single row.
Create a column family "doc_id".
Now, for each word, you create one row.
In this row, for each matching document you create one column (that's
the gotcha compared to a RDB design).
The name of the column is the doc id. The column's cell content is the weig=
ht.

So, following your example you'd get:

row id | column-family:column....
HELLO |  doc_id:2 | doc_id:3 | doc_id:4

and column values:
doc_id:2 | doc_id:3 | doc_id:4
12 |=A045 |=A036

HTH,

  Bernd


On Sat, Apr 23, 2011 at 09:56, JohnJohnGa <JohnJohnGa@gmail.com> wrote:
> Hi, I'm a beginner in HBase. I need to design my table. I want to play wi=
th the
> following information:
>
> At the date XX-XX-XXXX, the word 'HELLO' is in document 2,3,4 and the wei=
ght of
> each doc is 12,45,36 - My raw data: doc:D title:'i like potatoes',weight:=
W,date:D
>
> I created a table with, row: word, column:date, value:doc But I can't sto=
re
> multiple row with the same date, for the same word.
>
> Can we create multiple column families for a table? What can be the best =
way to
> design the schema?
>
> Thanks a lot
>
>