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: domain of doug.meil@explorysmedical.com
 designates 213.199.154.141 as permitted sender)
Received-SPF: pass (mail67-db3: domain of explorysmedical.com designates
 157.56.244.181 as permitted sender) client-ip=157.56.244.181;
 envelope-from=doug.meil@explorysmedical.com;
 helo=CH1PRD0410HT004.namprd04.prod.outlook.com ;.outlook.com ;
From: Doug Meil <doug.meil@explorysmedical.com>
To: "user@hbase.apache.org" <user@hbase.apache.org>
Subject: Re: Looking for a single row - HTable.get(Get) or Scan(Get)
Thread-Topic: Looking for a single row - HTable.get(Get) or Scan(Get)
Thread-Index: AQHNLiEfblIpMGQHy0CdfRCFCTrpNpbB7J4AgAABB4D//8iDgA==
Date: Wed, 9 May 2012 21:29:01 +0000
Message-ID: <CBD0599B.2BCF8%doug.meil@explorysmedical.com>
In-Reply-To: 
 <CAGpTDNeBWd0TM1dBvuQ8BaYsRQj8ZyK9j85KahLWOvs47RVbgw@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-ID: <D4F93D614723F44EB0F3AFC14AD57BC6@namprd04.prod.outlook.com>
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0


Also, there is multi-Get support as of 0.90.x to further optimize the RPC
calls if you need to make a bunch of calls.


On 5/9/12 4:47 PM, "Jean-Daniel Cryans" <jdcryans@apache.org> wrote:

>What Bryan said, also Scan(Get) is used internally in the region
>server code so that's probably why that constructor exists.
>
>But as a user you need to create the scanner, do next() then close it
>so using a straight Get saves 2 rpc.
>
>J-D
>
>On Wed, May 9, 2012 at 1:43 PM, Bryan Beaudreault
><bbeaudreault@hubspot.com> wrote:
>> Gets just boil down to single-row Scans.  I believe the only reason to
>>do
>> Scan s =3D new Scan(Get) would be if you need to add extra options onto
>>the
>> get.  Get's API is more simplified than Scan's.
>>
>> On Wed, May 9, 2012 at 4:19 PM, Kevin <kevin.macksamie@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> From what I can tell, there are two ways of scanning a table in HBase.
>>>I'm
>>> hoping to learn a bit by asking is the most efficient way to grab a
>>>single
>>> row from an HTable?
>>>
>>> One can ask the HTable directly by creating a Get object, or one can
>>>create
>>> a Scan object with a Get object and pass it along to the HTable.
>>>
>>> Maybe it doesn't matter. By looking at the source code I couldn't see
>>>how
>>> any one way might be faster/better than another.
>>>
>>> Thanks.
>>>
>