Re: Newbie question: Rowkey design

2013-12-17 Thread Wilm Schumacher
I was afraid of this answer and suspected it ;). I knew that the answer would depend on the actual setting, but I hoped, that there is is a little hint. Thanks a lot for your time and the answer. I will try it out with test data (and a simple table design) and will share my experiments when they a

Re: Newbie question: Rowkey design

2013-12-17 Thread yonghu
In my opinion, it really depends on your queries. The first one achieves data locality. There is no additional data transmit between different nodes. But this strategy sacrifices parallelism and the node which stores A will be a hot node if too many applications try to access A. The second appro

Re: Newbie question: Rowkey design

2013-12-16 Thread Tao Xiao
Sometimes row key design is a trade-off issue between load-balance and query : if you design row key such that you can query it very fast and convenient, maybe the records are not spread evenly across the nodes; if you design row key such that the records are spread evenly across the nodes, maybe i

Newbie question: Rowkey design

2013-12-16 Thread Wilm Schumacher
Hi, I'm a newbie to hbase and have a question on the rowkey design and I hope this question isn't to newbie-like for this list. I have a question which cannot be answered by knoledge of code but by experience with large databases, thus this mail. For the sake of explaination I create a small exam