You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Gurpreet Singh Bawa <gu...@snapdeal.com> on 2015/02/25 09:56:32 UTC

unable to limit number of records using scan with hbase version 0.94.15-cdh4.7.0

Hi Team

I am trying to apply a limit on my scan query, but cannot find a suitable
method in the Scan class that will help me do the same.

I am using org.apache.hbase:hbase 0.94.15-cdh4.7.0.

Kindly let me know if there is some other method available for limiting the
records.

Thanks
Gurpreet Singh Bawa
*SOFTWARE ENGINEER IN TEST II*
*M*: +91 8750472323, *T*: 011 47316200 *EXT*: 5634
237 OKHLA PHASE III, NEW DELHI 110 020, INDIADownload Our App[image: A]
<https://play.google.com/store/apps/details?id=com.snapdeal.main&utm_source=mobileAppLp&utm_campaign=android>[image:
A]
<https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1&mt=8&utm_source=mobileAppLp&utm_campaign=ios>[image:
W]
<http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f>

Re: unable to limit number of records using scan with hbase version 0.94.15-cdh4.7.0

Posted by Devaraja Swami <de...@gmail.com>.
Gurpreet, you can check this post on stack overflow:
http://stackoverflow.com/questions/14002948/command-like-sql-limit-in-hbase/28130609

On Wed, Feb 25, 2015 at 7:27 AM, Ted Yu <yu...@gmail.com> wrote:

> Gurpreet:
> Would the following method of Scan serve your needs ?
>
>  * To limit the maximum number of values returned for each call to next(),
>  * execute {@link #setBatch(int) setBatch}.
>
> Cheers
>
> On Wed, Feb 25, 2015 at 6:43 AM, Jean-Marc Spaggiari <
> jean-marc@spaggiari.org> wrote:
>
> > Hi Gurpreet,
> >
> > Can you share a part of the code you have to do this scan? What do you
> mean
> > by a limit? Can't you just stop calling next() if you get enough lines?
> >
> > 2015-02-25 3:56 GMT-05:00 Gurpreet Singh Bawa <
> gurpreet.bawa@snapdeal.com
> > >:
> >
> > > Hi Team
> > >
> > > I am trying to apply a limit on my scan query, but cannot find a
> suitable
> > > method in the Scan class that will help me do the same.
> > >
> > > I am using org.apache.hbase:hbase 0.94.15-cdh4.7.0.
> > >
> > > Kindly let me know if there is some other method available for limiting
> > the
> > > records.
> > >
> > > Thanks
> > > Gurpreet Singh Bawa
> > > *SOFTWARE ENGINEER IN TEST II*
> > > *M*: +91 8750472323, *T*: 011 47316200 *EXT*: 5634
> > > 237 OKHLA PHASE III, NEW DELHI 110 020, INDIADownload Our App[image: A]
> > > <
> > >
> >
> https://play.google.com/store/apps/details?id=com.snapdeal.main&utm_source=mobileAppLp&utm_campaign=android
> > > >[image:
> > > A]
> > > <
> > >
> >
> https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1&mt=8&utm_source=mobileAppLp&utm_campaign=ios
> > > >[image:
> > > W]
> > > <
> > >
> >
> http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f
> > > >
> > >
> >
>

Re: unable to limit number of records using scan with hbase version 0.94.15-cdh4.7.0

Posted by Ted Yu <yu...@gmail.com>.
Gurpreet:
Would the following method of Scan serve your needs ?

 * To limit the maximum number of values returned for each call to next(),
 * execute {@link #setBatch(int) setBatch}.

Cheers

On Wed, Feb 25, 2015 at 6:43 AM, Jean-Marc Spaggiari <
jean-marc@spaggiari.org> wrote:

> Hi Gurpreet,
>
> Can you share a part of the code you have to do this scan? What do you mean
> by a limit? Can't you just stop calling next() if you get enough lines?
>
> 2015-02-25 3:56 GMT-05:00 Gurpreet Singh Bawa <gurpreet.bawa@snapdeal.com
> >:
>
> > Hi Team
> >
> > I am trying to apply a limit on my scan query, but cannot find a suitable
> > method in the Scan class that will help me do the same.
> >
> > I am using org.apache.hbase:hbase 0.94.15-cdh4.7.0.
> >
> > Kindly let me know if there is some other method available for limiting
> the
> > records.
> >
> > Thanks
> > Gurpreet Singh Bawa
> > *SOFTWARE ENGINEER IN TEST II*
> > *M*: +91 8750472323, *T*: 011 47316200 *EXT*: 5634
> > 237 OKHLA PHASE III, NEW DELHI 110 020, INDIADownload Our App[image: A]
> > <
> >
> https://play.google.com/store/apps/details?id=com.snapdeal.main&utm_source=mobileAppLp&utm_campaign=android
> > >[image:
> > A]
> > <
> >
> https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1&mt=8&utm_source=mobileAppLp&utm_campaign=ios
> > >[image:
> > W]
> > <
> >
> http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f
> > >
> >
>

Re: unable to limit number of records using scan with hbase version 0.94.15-cdh4.7.0

Posted by Jean-Marc Spaggiari <je...@spaggiari.org>.
Hi Gurpreet,

Can you share a part of the code you have to do this scan? What do you mean
by a limit? Can't you just stop calling next() if you get enough lines?

2015-02-25 3:56 GMT-05:00 Gurpreet Singh Bawa <gu...@snapdeal.com>:

> Hi Team
>
> I am trying to apply a limit on my scan query, but cannot find a suitable
> method in the Scan class that will help me do the same.
>
> I am using org.apache.hbase:hbase 0.94.15-cdh4.7.0.
>
> Kindly let me know if there is some other method available for limiting the
> records.
>
> Thanks
> Gurpreet Singh Bawa
> *SOFTWARE ENGINEER IN TEST II*
> *M*: +91 8750472323, *T*: 011 47316200 *EXT*: 5634
> 237 OKHLA PHASE III, NEW DELHI 110 020, INDIADownload Our App[image: A]
> <
> https://play.google.com/store/apps/details?id=com.snapdeal.main&utm_source=mobileAppLp&utm_campaign=android
> >[image:
> A]
> <
> https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1&mt=8&utm_source=mobileAppLp&utm_campaign=ios
> >[image:
> W]
> <
> http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f
> >
>