-Re: Hbase Filter for RDBMS IN and AND query operation
lars hofhansl 2013-11-26, 17:49
ValueFilter would filter on the value of any qualifier and SingleColumnValueFilter can filter on a specific column.
You can combine the two with a FilterList with MUST_PASS_ALL.
I agree with JM, though, that you should give Phoenix a try.
From: Vineet Mishra <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sent: Tuesday, November 26, 2013 4:18 AM
Subject: Hbase Filter for RDBMS IN and AND query operation
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
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.