You can use FilterList to put the filters together: public FilterList(final Operator operator) {
AND -> MUST_PASS_ALL On Thu, Aug 4, 2016 at 2:07 AM, 乔彦克 <qya...@gmail.com> wrote: > Thanks for the advice, Ted. > I have the column prefix and the column value( in fact these two filters > are are in the same column), but don't have the column name, so I can't use > SingleColumnValueFilter. > *Now I use two qualifierFilters and a ColumnPrefixFilter to specify three > columns, and a value filter to filter the values. The logical between these > Filters are 'OR', but what I want is 'AND'? Is there some ways to help me > with that? Below is the filters I used.* > > QualifierFilter qfilter = new > QualifierFilter(CompareFilter.CompareOp.EQUAL, new > BinaryComparator(Bytes.toBytes("qualifier1"))); > QualifierFilter qfilter2 = new > QualifierFilter(CompareFilter.CompareOp.EQUAL, new > BinaryComparator(Bytes.toBytes("qualifier2"))); > > // *'e:cat' is the column prefix, and 'hello kitty' is the value of > 'e:cat?' column* > > ColumnPrefixFilter columnPrefixFilter = new > ColumnPrefixFilter(Bytes.toBytes("e:cat")); > > Filter valueFilter = new ValueFilter(CompareFilter.CompareOp.EQUAL, > new BinaryComparator( > Bytes.toBytes("hello kitty"))); > > > > Ted Yu <yuzhih...@gmail.com>于2016年8月4日周四 上午11:56写道: > > > For selecting column with same prefix, consider using ColumnPrefixFilter. > > > > For filtering value, consider using SingleColumnValueFilter. > > > > On Wed, Aug 3, 2016 at 7:52 PM, 乔彦克 <qya...@gmail.com> wrote: > > > > > Thanks for your reply, Ted. > > > Addition, if I want to filter another column -- one or many columns > with > > > one same column prefix, how can I deal with the filter or filter list. > > what > > > if I have to filter a value from the columns, beside to use > valueFilter, > > is > > > there another filter or filter to query this? > > > > > > eg: column prefix :* e:cat*, > > > specified columns maybe: *e:cat1, e:cat2, e:cat3,* > > > the value :* 'hello kitty' ,* > > > > > > Any advice is appreciated! > > > QiaoYanke > > > > > > > > > Ted Yu <yuzhih...@gmail.com>于2016年8月3日周三 上午3:15写道: > > > > > > > You can use the following method of Scan to specify columns to > > retrieve: > > > > > > > > public Scan addColumn(byte [] family, byte [] qualifier) { > > > > > > > > w.r.t. value comparison with cf:c3 column, consider using > > > > SingleColumnValueFilter. > > > > > > > > Cheers > > > > > > > > On Mon, Aug 1, 2016 at 6:56 PM, 乔彦克 <qya...@gmail.com> wrote: > > > > > > > > > Hi all, > > > > > > > > > > Currently I am using HBase client api to fetch data from HBase, > and I > > > > want > > > > > to get 3 columns (cf:c1,cf:c2,cf:c3), and some value equals cf:c3 > > > column, > > > > > But I don't know how to construct the filterList to achieve this, > So > > > How > > > > > can I do with that? > > > > > Any suggestion will be appreciated! > > > > > > > > > > > > > > > Best Regards, > > > > > QiaoYanke > > > > > > > > > > > > > > >