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 dontariq@gmail.com designates
 209.85.216.48 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAHxBGf+cSCrb_zBeWSy0PkcCxfRpoKmqPB-4ywzsCg-7=GfZ6Q@mail.gmail.com>
References: 
 <CAHxBGfJZPQFqXrW8QwSv63mCLzgqnvC2vO39AcfJ2Kc-o2N9RA@mail.gmail.com>
 <9ABAF877128BEB4E8E8C7F8ADD9F30976EADE6@PROD-EXCH-M3.corp.microstrategy.com>
 <CAHxBGf+cSCrb_zBeWSy0PkcCxfRpoKmqPB-4ywzsCg-7=GfZ6Q@mail.gmail.com>
From: Mohammad Tariq <dontariq@gmail.com>
Date: Mon, 26 Nov 2012 15:58:12 +0530
Message-ID: 
 <CAMVC6RPXbq_AtbXBfaxnn9e77QrH9A2B6Hxvf5QMKx7zTH=zQg@mail.gmail.com>
Subject: Re: Expert suggestion needed to create table in Hbase - Banking
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=047d7bea3bc65a1a0504cf636622

--047d7bea3bc65a1a0504cf636622
Content-Type: text/plain; charset=ISO-8859-1

Hello sir,

    You might become a victim of RS hotspotting, since the cutomerIDs will
be sequential(I assume). To keep things simple Hbase puts all the rows with
similar keys to the same RS. But, it becomes a bottleneck in the long run
as all the data keeps on going to the same region.

HTH

Regards,
    Mohammad Tariq


On Mon, Nov 26, 2012 at 3:53 PM, Ramasubramanian Narayanan <
ramasubramanian.narayanan@gmail.com> wrote:

> Hi,
> Thanks! Can we have the customer number as the RowKey for the customer
> (client) master table? Please help in educating me on the advantage and
> disadvantage of having customer number as the Row key...
>
> Also SCD2 we may need to implement in that table.. will it work if I have
> like that?
>
> Or
>
> SCD2 is not needed instead we can achieve the same by increasing the
> version number that it will hold?
>
> pls suggest...
>
> regards,
> Rams
>
> On Mon, Nov 26, 2012 at 1:10 PM, Li, Min <mili@microstrategy.com> wrote:
>
> > When 1 cf need to do split, other 599 cfs will split at the same time. So
> > many fragments will be produced when you use so many column families.
> > Actually, many cfs can be merge to only one cf with specific tags in
> > rowkey. For example, rowkey of customer address can be uid+'AD', and
> > customer profile can be uid+'PR'.
> >
> > Min
> > -----Original Message-----
> > From: Ramasubramanian Narayanan [mailto:
> > ramasubramanian.narayanan@gmail.com]
> > Sent: Monday, November 26, 2012 3:05 PM
> > To: user@hbase.apache.org
> > Subject: Expert suggestion needed to create table in Hbase - Banking
> >
> > Hi,
> >
> >   I have a requirement of physicalising the logical model... I have a
> > client model which has 600+ entities...
> >
> >   Need suggestion how to go about physicalising it...
> >
> >   I have few other doubts :
> >   1) Whether is it good to create a single table for all the 600+
> columns?
> >   2) To have different column families for different groups or can it be
> > under a single column family? For example, customer address can we have
> as
> > a different column family?
> >
> >   Please help on this..
> >
> >
> > regards,
> > Rams
> >
>

--047d7bea3bc65a1a0504cf636622--