hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ramasubramanian Narayanan <ramasubramanian.naraya...@gmail.com>
Subject Re: Expert suggestion needed to create table in Hbase - Banking
Date Mon, 26 Nov 2012 10:23:01 GMT
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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message