Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
Hi,

*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

regards,
Rams
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB