-Re: Hbase table with a nested entity
Michel Segel 2013-02-27, 12:23
Uhm you can easily do this in HBase a couple of different ways. :-)
Your option 2 is this solution he wants.
Or option 3, store the data into a map or some serializable object, (Single column)
Option 4, use Avro single column
Option 5, if data set is large enough, store it in a sequence file and use HBase as index.
You just need to free yourself from thinking only in terms of ER modeling.
Sent from a remote device. Please excuse any typos...
On Feb 27, 2013, at 5:06 AM, yonghu <[EMAIL PROTECTED]> wrote:
> 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
> 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.
> 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 )
>> please help me.