Hbase filter with column and value.

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.

Re: Hbase filter with column and value.

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

Multiple filterlist

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

Re: Multiple filterlist

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

Re: Multiple filterlist

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

Re: Combining filterlists

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

Re: Combining filterlists

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.

HBase-Connectors Library on Maven

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