Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase, mail # user - Hbase Filter for RDBMS IN and AND query operation


Copy link to this message
-
Re: Hbase Filter for RDBMS IN and AND query operation
lars hofhansl 2013-11-26, 17:50
Oops. Disregard my other reply then, you figured it out yourself.

________________________________
 From: Vineet Mishra <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sent: Tuesday, November 26, 2013 6:10 AM
Subject: Re: Hbase Filter for RDBMS IN and AND query operation
 

Yes,

Applying Filter List with Pass ALL containing two filters for name and flag
and iteratively adding it(previous filter list) to another filter list with
(Pass One).
On Tue, Nov 26, 2013 at 7:27 PM, Jean-Marc Spaggiari <
[EMAIL PROTECTED]> wrote:

> Hi vineet,
>
> So how have you solved that finally? Using filters?
>
> JM
>
>
> 2013/11/26 Vineet Mishra <[EMAIL PROTECTED]>
>
> > Thanks Marc,
> >
> > I got it working!
> >
> >
> > On Tue, Nov 26, 2013 at 6:49 PM, Jean-Marc Spaggiari <
> > [EMAIL PROTECTED]> wrote:
> >
> > > Hum.
> > >
> > > Phoenix guys will most probably reply that Phoenix is the solution for
> > that
> > > ;) And I will probably agree with them.
> > >
> > > I don't see any filter which can do that within a single call.
> > >
> > > One option I will apply in your case is to do a scan+filter on the
> flag=1
> > > value then do a get name based on the return keys. But that might be to
> > > many gets if you have a lot of values returned.
> > >
> > > Based on your usecase and the size of the name column, another one is
> to
> > > build a MR job. In the map method you keep track of the name and flag
> > > columns, and if you get the 2 before going to the new row, you emit it
> to
> > > another table.
> > >
> > > HTH.
> > >
> > > JM
> > >
> > >
> > > 2013/11/26 Vineet Mishra <[EMAIL PROTECTED]>
> > >
> > > > Hi All,
> > > >
> > > > I want to fetch some rows from a table where the value for the
> > > > Qualifier(say name) is any of ("joseph" ,"sandy", "lar" ) and another
> > > > Qualifier(say flag) should always be 1.
> > > >
> > > > I am making multi SingleColumnValueFilter scan on a Table with
> Compare
> > > > Operator to
> > > > Equal and those list of values for each Filter.
> > > > Applying multi SingleColumnValueFilter is going good, only till I am
> > not
> > > > including flag, and without flag my result are incomplete.
> > > >
> > > > Can you tell me which filter or approach to use to get my expected
> > > result.
> > > >
> > > > Thanks!
> > > >
> > >
> >
>