Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: local policy includes SPF record at
 spf.trusted-forwarder.org)
MIME-Version: 1.0
In-Reply-To: <20131107072725.GA27036@archbookPro>
References: <20131107072725.GA27036@archbookPro>
From: Jean-Marc Spaggiari <jean-marc@spaggiari.org>
Date: Thu, 7 Nov 2013 06:55:16 -0500
Message-ID: 
 <CAPQV63UtAFZFjmQ3S=Do1YtMsK1SuFTCZX_2Equ15z-bqFPkAQ@mail.gmail.com>
Subject: Re: Combining filters in the HBase shell
To: user <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=047d7bd6ae8c9905c204ea94f14b

--047d7bd6ae8c9905c204ea94f14b
Content-Type: text/plain; charset=UTF-8

Hi Arvid,

Based on the shell help:
  hbase> scan 't1', {FILTER => "(PrefixFilter ('row2') AND (QualifierFilter
(>=, 'binary:xyz'))) AND (TimestampsFilter ( 123, 456))"}

Can you try without the ".new" when using multiple filters?

Other option, can you try to define you filters first and then reference
them on your scan?

JM


2013/11/7 Arvid Warnecke <arvid@nostalgix.org>

> Hello,
>
> I have some issues when I try to use filters in the shell.
> When I use only one filter everything is okay:
>
> scan 'rawdb', { COLUMNS => 'raw:a', FILTER => \
> SingleColumnValueFilter.new(Bytes.toBytes('raw'), Bytes.toBytes('a'), \
> CompareFilter::CompareOp.valueOf('EQUAL'),
> SubstringComparator.new('154442')), \
> LIMIT => 3 }
>
> But when I try to combine two filters like that:
>
> scan 'rawdb', { COLUMNS => 'raw:a', FILTER =>
> "(SingleColumnValueFilter.new(Bytes.toBytes('raw'), Bytes.toBytes('a'), \
> CompareFilter::CompareOp.valueOf('EQUAL'),
> SubstringComparator.new('154442')) \
> AND (SingleColumnValueFilter.new(Bytes.toBytes('raw'), Bytes.toBytes('u'),
> \
> CompareFilter::CompareOp.valueOf('EQUAL'),
> SubstringComparator.new('blafasel')))", \
> LIMIT => 3 }
>
> I get the following error:
> java.lang.IllegalArgumentException: Filter Name
> SingleColumnValueFilter.new not supported
>
> Can somebody tell me what I am doing wrong here?
>
> Best regards,
> Arvid
>
> --
> ThreePiO was right: Let the Wookiee win.
>

--047d7bd6ae8c9905c204ea94f14b--