RES: Rowkey hashing to avoid hotspotting

2012-07-18 Thread Cristofer Weber
Hi Anand! I see... sorry for being so curious, but since I started studying HBase I am curious about how people are modeling their tables, and in what kinds of systems HBase is in use. Have you evaluated recording your reports in a distinct CF using timestamps as column qualifiers? It's my cur

RES: Rowkey hashing to avoid hotspotting

2012-07-17 Thread Cristofer Weber
So, Anand, there are some things that can help, but again, most of them are related with the famous access patterns. Sometimes is not easy to get more information about them in advance, but if you are replacing another system you can study its data distribution, grouping for counts, mean, chan

RES: Rowkey hashing to avoid hotspotting

2012-07-16 Thread Cristofer Weber
Hi Anand, As usual, the answer is that 'it depends' :) I think that the main question here is: why are you afraid that this setup would lead to region server hotspotting? Is because you don't know how your production data will seems? Based on what you told about your rowkey, you will query m