Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase >> mail # user >> Expert suggestion needed to create table in Hbase - Banking


Copy link to this message
-
Re: Expert suggestion needed to create table in Hbase - Banking
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 <[EMAIL PROTECTED]> 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:
> [EMAIL PROTECTED]]
> Sent: Monday, November 26, 2012 3:05 PM
> To: [EMAIL PROTECTED]
> 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
>