Re: basic question for newbie

2011-10-10 Thread Syg raf
Thank you very much all of you. With all this suggestion, i have enough information to get going with my first HBase implementation. Regards, Sygura --- On Mon, Oct 10, 2011 at 9:01 AM, Doug Meil wrote: > > You'll want to review this too... > > http://hbase.apache.org/book.html#schema > > > > > >

Re: basic question for newbie

2011-10-10 Thread Doug Meil
You'll want to review this too... http://hbase.apache.org/book.html#schema On 10/10/11 2:51 AM, "Sonal Goyal" wrote: >One possible schema for your case could be: > >rowkey: book. Column familty: author, qualifiers one, two, three... >AND similar table for authors >rowkey: author, Column fa

Re: basic question for newbie

2011-10-09 Thread Sonal Goyal
One possible schema for your case could be: rowkey: book. Column familty: author, qualifiers one, two, three... AND similar table for authors rowkey: author, Column family books Best Regards, Sonal Crux: Reporting for HBase Nube Technologies

Re: basic question for newbie

2011-10-09 Thread Li Pi
Assuming you want this to be done in constant time: You'd have a Author table and a Book table. For the author table, the key would be the name of the author, and the value would be the book. For the book table, the key would be the name of the book, and the value would be the author. This will

Re: basic question for newbie

2011-10-09 Thread Syg raf
I want to be able to get an author or a book and also, i want to be able to get all the authors of a book and all the books of an author (N to N relation in SQL db). Does that give you enough information? Thanks On Mon, Oct 10, 2011 at 2:16 AM, Sonal Goyal wrote: > How do you want to query your

Re: basic question for newbie

2011-10-09 Thread Sonal Goyal
How do you want to query your data? This question decides how you can save your data. Best Regards, Sonal Crux: Reporting for HBase Nube Technologies On Mon, Oct 10, 2011 at 11:17 AM, Syg raf

Re: basic question for newbie

2011-10-09 Thread Syg raf
Thanks Sam for the link, I'm going to get the book ordered. Just to start and get familliar with HBase, can yo tell if everything go into one table and the data separated into column families? if not, based on what we create multiple tables ? Thanks On Mon, Oct 10, 2011 at 1:28 AM, Sam Seigal w

Re: basic question for newbie

2011-10-09 Thread Sam Seigal
Start off with the HBase book, great resource for getting started: http://ofps.oreilly.com/titles/9781449396107/ On Sun, Oct 9, 2011 at 10:25 PM, Syg raf wrote: > Hello folks, > > I'm just starting with HBase and have a couple of rudimentary questions > about how to use it: > > I have a simple

basic question for newbie

2011-10-09 Thread Syg raf
Hello folks, I'm just starting with HBase and have a couple of rudimentary questions about how to use it: I have a simple Java program that have been developer for the purpose of learning HBase, the program was built with MySQL as database, it contain 3 tables: Authors, Books and AuthorBook (for