Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (athena.apache.org: domain of fancyerii@gmail.com
 designates 209.85.217.179 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAPQV63Vtdxk=+e2CQw246kCYPBQ5B-6cy6yFmwEsPU-CuyhA3g@mail.gmail.com>
References: 
 <CAFAd71VE+7dP-VKrsjuSoB=BGvW0=Los-8MoSuCf9F5LNULSAg@mail.gmail.com>
	<CAMVC6ROLH_0riBDvQU_2j0GDuBQoCO5GDyG1r54Yp_zaRa0mhA@mail.gmail.com>
	<CAPQV63Vtdxk=+e2CQw246kCYPBQ5B-6cy6yFmwEsPU-CuyhA3g@mail.gmail.com>
Date: Mon, 14 Apr 2014 19:52:28 +0800
Message-ID: 
 <CAFAd71VctE58R3MoBd-TG_eGCus6AitowdAvBvmDaKoazi=jqg@mail.gmail.com>
Subject: Re: Scan vs map-reduce
From: Li Li <fancyerii@gmail.com>
To: user@hbase.apache.org
Content-Type: text/plain; charset=UTF-8

I need to get about 20,000 rows from the table. the table is about
1,000,000 rows.
my first version is using 20,000 Get and I found it's very slow. So I
modified it to a scan and filter unrelated rows in the client.
maybe I should write a coprocessor. btw, is there any filter available
for me? something like sql statement where rowkey in('abc', 'abd'
....). a very long in statement

On Mon, Apr 14, 2014 at 7:46 PM, Jean-Marc Spaggiari
<jean-marc@spaggiari.org> wrote:
> Hi Li Li,
>
> If you have more than one region, might be useful. MR will scan all the
> regions in parallel. If you do a full scan from a client API with no
> parallelism, then the MR job might be faster. But it will take more
> resources on the cluster and might impact the SLA of the other clients, if
> any,
>
> JM
>
>
> 2014-04-14 2:42 GMT-04:00 Mohammad Tariq <dontariq@gmail.com>:
>
>> Well, it depends. Could you please provide some more details?It will help
>> us in giving a proper answer.
>>
>> Warm Regards,
>> Tariq
>> cloudfront.blogspot.com
>>
>>
>> On Mon, Apr 14, 2014 at 11:38 AM, Li Li <fancyerii@gmail.com> wrote:
>>
>> > I have a full table scan which cost about 10 minutes. it seems a
>> > bottleneck for our application. if use map-reduce to rewrite it. will
>> > it be faster?
>> >
>>