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
