Hi, Thanks for your response, But you are suggesting me a tall and narrow table which is not working for me right now. As my use case involves real-time solution I need to retrieve data from hbase table within one or two seconds. I have tried as you suggested which may lead to 1000 rows for a given id which takes more than a minute in retrieval process.
Thanks Rajeshkumar On Mon, Dec 14, 2015 at 3:29 PM, Jean-Marc Spaggiari < [email protected]> wrote: > Hi, > > HBase is a key value sotre. So what you are pushing here will be stored as: > 1002 | xxx | www.sample.com | xx:xx:xx > 1003 | yyy | www.url,com | xx:xx:yy > 1002 | xxx | url.com | yy:yy:yy > 1002 | xxx | urrl2.com | zz:zz:zz > > HOWEVER.... HBase will never split a region withing a key and keys are > always ordered. So at the end, what you will have exactly is: > > -------------------------------------------------------------- > 1002 | xxx | url.com | yy:yy:yy > 1002 | xxx | urrl2.com | zz:zz:zz > 1002 | xxx | www.sample.com | xx:xx:xx > -------------------------------------------------------------- > 1003 | yyy | www.url,com | xx:xx:yy > -------------------------------------------------------------- > > The only places where HBase will splis are marked with "-----" > > > This is if 1002-xxx is your key and "url.com" is your column qualifier. > > HTH > > JMS > > > 2015-12-14 3:39 GMT-05:00 Rajeshkumar J <[email protected]>: > > > Hi, > > > > I am going to use flat-wide tables in Hbase for my usecase and I have > > some doubts regarding this. > > > > 1. As per my knowledge flat-wide stores one column value as key and > > others as its values in a key-value pair relationship ( correct me if I > am > > wrong). > > > > I am having row as follows > > > > id | name | url | time > > > > 1002 | xxx | www.sample.com | xx:xx:xx > > 1003 | yyy | www.url,com | xx:xx:yy > > 1002 | xxx | url.com | yy:yy:yy > > 1002 | xxx | urrl2.com | zz:zz:zz > > > > > > > > I need to store it in flat-wide table as follows > > > > 1002 | xxx | www.sample.com | xx:xx:xx | 1002 | xxx | url.com | > yy:yy:yy > > | > > 1002 | xxx | urrl2.com | zz:zz:zz > > 1003 | yyy | www.url,com | xx:xx:yy > > > > How to store it like this? > > Can any on help me in this? > > >
