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

Switch to Threaded View
HBase >> mail # user >> about hbase rowkey and column name design

Copy link to this message
about hbase rowkey and column name design
1. On HBase reference guide section
We know that rowkey design should not using Monotonically Increasing Row
Keys/Timeseries Data ,but if we need a time stamp sort data or a top list
data, how to design the row key?

2. If I want statistics users' login data. I need to get one day somebody
logins details(on what time, client info, etc.), to design like this:
rowkey                                             column
userid:date (fmt:2013-01-01)              c:time   (colum fmt c:12:38:56)
   value (client info)

get 't1','zhouhh:2013-01-01'

zhouhh:2013-01-01          column=c:12:38:56
 value=2013-01-01 12:38:56:zhouhh
zhouhh:2013-01-01          column=c:13:42:58
 value=2013-01-01 13:42:58:zhouhh

there will be a lot of column names,but it is efficient to get one user on
one day login info.
 there are any problems?

Andy Zhou