Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
HBase >> mail # user >> basic question for newbie


+
Syg raf 2011-10-10, 05:25
+
Sam Seigal 2011-10-10, 05:28
+
Syg raf 2011-10-10, 05:47
+
Sonal Goyal 2011-10-10, 06:16
+
Syg raf 2011-10-10, 06:35
+
Li Pi 2011-10-10, 06:48
Copy link to this message
-
Re: basic question for newbie
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 <https://github.com/sonalgoyal/crux>
Nube Technologies <http://www.nubetech.co>

<http://in.linkedin.com/in/sonalgoyal>

On Mon, Oct 10, 2011 at 12:05 PM, Syg raf <[EMAIL PROTECTED]> wrote:

> 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 <[EMAIL PROTECTED]>
> wrote:
>
> > How do you want to query your data? This question decides how you can
> save
> > your data.
> >
> > Best Regards,
> > Sonal
> > Crux: Reporting for HBase <https://github.com/sonalgoyal/crux>
> > Nube Technologies <http://www.nubetech.co>
> >
> > <http://in.linkedin.com/in/sonalgoyal>
> >
> >
> >
> >
> >
> > On Mon, Oct 10, 2011 at 11:17 AM, Syg raf <[EMAIL PROTECTED]> wrote:
> >
> > > 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 <[EMAIL PROTECTED]>
> wrote:
> > >
> > > > 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 <[EMAIL PROTECTED]>
> 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 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 the N to N relation).
> > > > > I am wondering if someone can help me to do the same with HBase,
> what
> > > > could
> > > > > the schema be?
> > > > > Any recommendations are welcome and just keep in mind that I'm just
> > > > > beginning, simple explanation would be great.
> > > > >
> > > > > Thanks a lot,
> > > > > Sygura.
> > > > >
> > > >
> > >
> >
>
+
Doug Meil 2011-10-10, 13:01
+
Syg raf 2011-10-10, 15:38
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB