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
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!
> > >
> >
>