-Re: Hbase Filter for RDBMS IN and AND query operation
Jean-Marc Spaggiari 2013-11-26, 13:19
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
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.