Hi,
Im trying to filter a Hbase table where column names are like foo_1 foo_2
foo_3..
A sql equalent query will be like
"Select * from tablename where colunm name like 'foo_%' and value ='value'"
The difficulty is that Im not able to do a filter for both column and value
together.
Hi Jieshan
Thanks a lot for the reply.
BUT in this case i don't have the column name since im using ColumnPrefixFilter.
Is there a way get the result without adding the particular column and column
family name to scanner object??
Is there a way to add multiple filter list to a scan object.
ie,
scan.setFilter(Filterlist1);
scan.setFilter(Filterlist2);
scan.setFilter(Filterlist3);
Where Filterlist1,Filterlist2 are objects of FilterList and it contains
combination of filters like ColumnPrefixFilter,ValueFilter.
Or in anothe
Guys i understand this... But my question i want to add multiple filterlists...
Something like this
FilterList list1 = new FilterList(FilterList.Operator.MUST_PASS_ONE);
SingleColumnValueFilter filter1 = new SingleColumnValueFilter(
cf,
column,
CompareOp.EQUAL,
Byte
FilterList listOfFilters = new FilterList (FilterList.Operator.MUST_PASS_ALL);
FilterList listOfFilters1 = new FilterList (FilterList.Operator.MUST_PASS_ALL);
FilterList listOfFilters2 = new FilterList (FilterList.Operator.MUST_PASS_ALL);
SingleColumnValueFilter SingleFilter1 = new
Sin
Hbase version is 0.90.5,..
Im not sure weather the following hierarchy is supported...
Filterlist1 = ColumnPrefixFilter1 + valueFilter1
Filterlist2 = ColumnPrefixFilter2 + valueFilter2
Filterlist3 = ColumnPrefixFilter3 + valueFilter3
Filterlist = Filterlist1 + Filterlist2 + Filterlist3
Ny
Thanks for the reply Suraj,
But in my case i need row-key when both the conditions are satisfied.
MUST_PASS_ONE will give the result when one condition is true.
o_wide.png]<http://www.radiantsolutions.com>
Davis R. Silverman
Associate Software Development Engineer
+1.240.543.4339 office
davis.silverman@radiantsolutionscom<mailto:davis.silverman@radiantsolutionscom>
This electronic communication and any attachments may contain confidential and
proprietary info