hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject Re: Hbase Filter for RDBMS IN and AND query operation
Date Tue, 26 Nov 2013 13:19:29 GMT
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 <clearmidoubt@gmail.com>

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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message