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
Jean-Marc Spaggiari 2013-11-26, 13:19
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!
>