Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
MIME-Version: 1.0
In-Reply-To: <CALYtcUiEhJEjsxAfe1stuBCDhLbLkb+sFBN2K_6qTePhm2_kqg@mail.gmail.com>
References: <CALYtcUgD+mnOR4Yar6_skke4U=voEEu+TSd0pjFsJUoTHUk1og@mail.gmail.com>
 <CALte62wF9rehFsAizL3+sGcOFEc0ba4-5iGa0TpdONNaak=5JQ@mail.gmail.com>
 <CALYtcUgetRK3f9NVt3gsb6UBkj771w5nxw5n4i11kePNgU8pSg@mail.gmail.com>
 <CALte62wMdPLkiauDstEvWyoCJXtOtS_wGodBciWW=BHTxWLDuQ@mail.gmail.com> <CALYtcUiEhJEjsxAfe1stuBCDhLbLkb+sFBN2K_6qTePhm2_kqg@mail.gmail.com>
From: Ted Yu <yuzhihong@gmail.com>
Date: Thu, 4 Aug 2016 02:13:35 -0700
Message-ID: <CALte62zvQP4R-5Un88Q-zE5P378CQmrWo01xCw36-hfHvx5v-Q@mail.gmail.com>
Subject: Re: query multiple specified columns using filterlist
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=94eb2c147ffe5e53fa05393b5db9
archived-at: Thu, 04 Aug 2016 09:13:51 -0000

--94eb2c147ffe5e53fa05393b5db9
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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, =E4=B9=94=E5=BD=A6=E5=85=8B <qyanke@gmail.c=
om> 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 u=
se
> SingleColumnValueFilter.
> *Now I use two qualifierFilters and a ColumnPrefixFilter to specify three
> columns, and a value filter to filter the values. The logical between the=
se
> 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 =3D new
> QualifierFilter(CompareFilter.CompareOp.EQUAL, new
> BinaryComparator(Bytes.toBytes("qualifier1")));
> QualifierFilter qfilter2 =3D 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 =3D new
> ColumnPrefixFilter(Bytes.toBytes("e:cat"));
>
> Filter valueFilter =3D new ValueFilter(CompareFilter.CompareOp.EQUAL,
> new BinaryComparator(
>         Bytes.toBytes("hello kitty")));
>
>
>
> Ted Yu <yuzhihong@gmail.com>=E4=BA=8E2016=E5=B9=B48=E6=9C=884=E6=97=A5=E5=
=91=A8=E5=9B=9B =E4=B8=8A=E5=8D=8811:56=E5=86=99=E9=81=93=EF=BC=9A
>
> > For selecting column with same prefix, consider using ColumnPrefixFilte=
r.
> >
> > For filtering value, consider using SingleColumnValueFilter.
> >
> > On Wed, Aug 3, 2016 at 7:52 PM, =E4=B9=94=E5=BD=A6=E5=85=8B <qyanke@gma=
il.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 <yuzhihong@gmail.com>=E4=BA=8E2016=E5=B9=B48=E6=9C=883=E6=97=
=A5=E5=91=A8=E4=B8=89 =E4=B8=8A=E5=8D=883:15=E5=86=99=E9=81=93=EF=BC=9A
> > >
> > > > 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, =E4=B9=94=E5=BD=A6=E5=85=8B <qyanke=
@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=EF=BC=9F
> > > > > Any suggestion will be appreciated!
> > > > >
> > > > >
> > > > > Best Regards=EF=BC=8C
> > > > > QiaoYanke
> > > > >
> > > >
> > >
> >
>

--94eb2c147ffe5e53fa05393b5db9--