reg HBase table structure

[Deepa Jayaveer <de...@tcs.com>]

Hi,
I’m running HBase 0.94.  We are trying to create a table to load 
store -product level sales /margin /sales units details at weekly level 
for 3 years. 
Like
Store1 -Product1 -Week1 - sales$- Margin$- Sales unit $
Store1 -Product1 -Week2- sales$- Margin$- Sales unit $
..............
Store1 -Product1 -Week156- sales$- Margin$- Sales unit $

The row key is Store Id _Product Id_WeekID but   it is taking long time to 
fetch when we do sub string  to get
the aggregated sales  at product level .

I really doubt on the table design. Can i store the data vertically weekly 
level or can i store the sku data with all the  sales information 
columnwise. can anyone suggest on this.

Thanks
Deepa

.








=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you