Mailing-List: contact dev-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of neerjapub@gmail.com designates
 209.85.210.43 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAGpTDNeo6qN6jZ418OcemOUiDVNm4R6hJZN-RpdPO03qOFX3+w@mail.gmail.com>
References: 
 <CAKEwePJjDqhY17ToP81BhDJ3Ro-arTp0Z1XYLdjYW7XNY_MsHA@mail.gmail.com>
	<CAGpTDNeo6qN6jZ418OcemOUiDVNm4R6hJZN-RpdPO03qOFX3+w@mail.gmail.com>
Date: Mon, 29 Aug 2011 18:00:49 -0700
Message-ID: 
 <CAKEwePJ6dwpt6YmsB0Ug=HYNHoxHwLP7sDNkKo2OS-oLy57vnw@mail.gmail.com>
Subject: Re: HBase Scan returns fewer columns after a few minutes of insertion
From: Neerja Bhatnagar <neerjapub@gmail.com>
To: dev@hbase.apache.org
Content-Type: multipart/alternative; boundary=000e0cd28d98e00f0404abae8a86

--000e0cd28d98e00f0404abae8a86
Content-Type: text/plain; charset=ISO-8859-1

Hi J-D,

Thanks! I do scan 'tablename' on the shell, and I can see all 3 columns in
the 1 column family for a row. I haven't set any TTL on the table or result
scanner.
Any other suggestions would be very welcome. I was getting the same response
with result.getFamilyMap() and I moved to result.getMap() thinking I was
using the wrong api.

Cheers, Neerja

On Mon, Aug 29, 2011 at 5:23 PM, Jean-Daniel Cryans <jdcryans@apache.org>wrote:

> (sending to user@ and bbcing dev@ since this is a user question)
>
> That type of problem can be "fun" to debug, did you try with the shell
> to query the data? Do you get a different result?
>
> BTW, any TTL set on that table?
>
> J-D
>
> On Mon, Aug 29, 2011 at 5:09 PM, Neerja Bhatnagar <neerjapub@gmail.com>
> wrote:
> > Hi,
> >
> > I am sorry if this question has been resolved before. Thank you for your
> > help.
> >
> > I am seeing really strange behavior with HBase Scan.
> >
> > I insert 1 row into a table named test, 1 col family named testColFam,
> and 3
> > columns : foo (with value foo), bar (with value bar), and id (a unique
> id).
> >
> > I wait 5 minutes, and run the following code to retrieve the row ---
> >
> > HTablePool htablePool = new HTablePool(config, maxsize);
> >
> > HTable table = (HTable) htablePool.getTable("test"); // test is the
> > tablename
> >
> > Scan scan = new Scan();
> > scan.addFamily(Bytes.toBytes("testColFam"));
> > scan.setStartRow(Bytes.toBytes("")); // scan from the first row
> > scan.setBatch(batchSize);
> >
> > ResultScanner resScanner = table.getScanner(scan);
> > Iterator<Result> resultIterator = resultScanner.iterator();
> >
> > Result result = resultIterator.next();
> >
> > result.getMap();
> >
> > the result.getMap() behaves differently based on time-elapsed. If I run
> this
> > code as soon as I have inserted the data, the 3 columns in the 1 row are
> > returned as expected.
> >
> > But after some time elapses, scan returns fewer columns per row each
> time.
> >
> > Can anyone please help me with this? Please let me know if you need more
> > information.
> >
> > Do I need to set the timerange or something to make sure that all columns
> > are returned?
> >
> > Cheers, Neerja
> >
>

--000e0cd28d98e00f0404abae8a86--