Hello Dastgiri, I don't think HBase can support original nested schema which you want to define. But you can still store your data in HBase. I figured out several possible solutions:
1. row_key: profileid + profilename + date, the column will be monthwiseProfileCount:uk and so on. However, this approach will cause data redundancy (profileid + profilename will repeatably appear), and the data which belongs to the same user are separated into different tuples. 2. row_key: profileid + profilename. the column will be monthwiseProfileCount: date(e.g. 12/10/2010)/uk and so on. The benefit of this approach is that all the data belongs to the same user group together. However, as date is one part of column information. It will cause to create many columns if the value range of date is wide. regards! Yong On Wed, Feb 27, 2013 at 5:38 AM, Dastagiri S Shaik <[email protected]> wrote: > Hi All, > > I need to define a schema > > profileid (integer) > profilename (String) > monthwiseProfileCount (is having ) > 12/10/2010--> > uk:200 > us:300 > india:500 > > 12/11/2010--> > uk:200 > us:300 > india:500 > > > please help me. > > Regards > Dastgiri > >
