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

Switch to Threaded View
HBase >> mail # user >> Regarding Rowkey and Column Family

Copy link to this message
Regarding Rowkey and Column Family

*Table Name : Customer*
*Field Name         Column Family*
Customer Number      CF1
DOB                  CF1
FName                CF1
MName                CF1
LName                CF1
Address Type         CF2
Address Line1        CF2
Address Line2        CF2
Address Line3        CF2
Address Line4        CF2
State                CF2
City                 CF2
Country              CF2

Is it good to have rowkey as follows for the same table?

Rowkey Design:
For CF1 : Customer Number + YYYYMMD (business date)
For CF2 : Customer Number + Address Type

Note :
Address Type can be any of HOME/OFFICE/OTHERS