You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Dalia Sobhy <da...@hotmail.com> on 2012/11/18 01:02:45 UTC
Hive and Hbase performance
I want to ask if a Hive Count or Scan Query will provide better performance when adding more nodes ??
if an Hbase Count or Scan Query will provide better performance when adding more nodes ??
Re: Hive and Hbase performance
Posted by Nitin Pawar <ni...@gmail.com>.
Dalia,
by adding a node I hope on hive side you want to increase the hadoop
cluster size.
in general performance is directly related to how much data you have vs how
much computation power you have. More the data better to have larger
computational power.
I am not guru of hbase but following link in details explains about hbase
performance benchmarks with multiple options in view
http://hbase.apache.org/book/casestudies.perftroub.html
On Mon, Nov 19, 2012 at 2:18 PM, Dalia Sobhy <da...@hotmail.com>wrote:
>
> Hi Anil,
>
> I thought so, but when checking this blog I got confused, Could u check it
> and give me your feedback?
>
>
> http://stackoverflow.com/questions/9300840/is-running-scan-on-hbase-faster-if-running-hbase-on-more-than-1-machine?rq=1
>
> Thanks,
>
> > From: anilgupta84@gmail.com
> > Date: Sat, 17 Nov 2012 16:51:31 -0800
> > Subject: Re: Hive and Hbase performance
> > To: user@hbase.apache.org
> >
> > Hi Dalia,
> >
> > The usual and short answer is Yes. Both, HBase and Hive will provide
> better
> > performance on adding more nodes since they provide horizontal
> scalability.
> >
> > HTH,
> > Anil
> >
> >
> >
> > On Sat, Nov 17, 2012 at 4:02 PM, Dalia Sobhy <dalia.mohsobhy@hotmail.com
> >wrote:
> >
> >>
> >> I want to ask if a Hive Count or Scan Query will provide better
> >> performance when adding more nodes ??
> >>
> >> if an Hbase Count or Scan Query will provide better performance when
> >> adding more nodes ??
> >
> >
> >
> >
> > --
> > Thanks & Regards,
> > Anil Gupta
>
>
> Sent from my iPad
>
> On Nov 18, 2012, at 3:19 AM, "Dalia Sobhy" <da...@hotmail.com>
> wrote:
>
> >
> > Hi Anil,
> >
> > I thought so, but when checking this blog I got confused, Could u check
> it and give me your feedback?
> >
> >
> http://stackoverflow.com/questions/9300840/is-running-scan-on-hbase-faster-if-running-hbase-on-more-than-1-machine?rq=1
> >
> > Thanks,
> >
> >> From: anilgupta84@gmail.com
> >> Date: Sat, 17 Nov 2012 16:51:31 -0800
> >> Subject: Re: Hive and Hbase performance
> >> To: user@hbase.apache.org
> >>
> >> Hi Dalia,
> >>
> >> The usual and short answer is Yes. Both, HBase and Hive will provide
> better
> >> performance on adding more nodes since they provide horizontal
> scalability.
> >>
> >> HTH,
> >> Anil
> >>
> >>
> >>
> >> On Sat, Nov 17, 2012 at 4:02 PM, Dalia Sobhy <
> dalia.mohsobhy@hotmail.com>wrote:
> >>
> >>>
> >>> I want to ask if a Hive Count or Scan Query will provide better
> >>> performance when adding more nodes ??
> >>>
> >>> if an Hbase Count or Scan Query will provide better performance when
> >>> adding more nodes ??
> >>
> >>
> >>
> >>
> >> --
> >> Thanks & Regards,
> >> Anil Gupta
> >
>
--
Nitin Pawar
Re: Hive and Hbase performance
Posted by Dalia Sobhy <da...@hotmail.com>.
Hi Anil,
I thought so, but when checking this blog I got confused, Could u check it and give me your feedback?
http://stackoverflow.com/questions/9300840/is-running-scan-on-hbase-faster-if-running-hbase-on-more-than-1-machine?rq=1
Thanks,
> From: anilgupta84@gmail.com
> Date: Sat, 17 Nov 2012 16:51:31 -0800
> Subject: Re: Hive and Hbase performance
> To: user@hbase.apache.org
>
> Hi Dalia,
>
> The usual and short answer is Yes. Both, HBase and Hive will provide better
> performance on adding more nodes since they provide horizontal scalability.
>
> HTH,
> Anil
>
>
>
> On Sat, Nov 17, 2012 at 4:02 PM, Dalia Sobhy <da...@hotmail.com>wrote:
>
>>
>> I want to ask if a Hive Count or Scan Query will provide better
>> performance when adding more nodes ??
>>
>> if an Hbase Count or Scan Query will provide better performance when
>> adding more nodes ??
>
>
>
>
> --
> Thanks & Regards,
> Anil Gupta
Sent from my iPad
On Nov 18, 2012, at 3:19 AM, "Dalia Sobhy" <da...@hotmail.com> wrote:
>
> Hi Anil,
>
> I thought so, but when checking this blog I got confused, Could u check it and give me your feedback?
>
> http://stackoverflow.com/questions/9300840/is-running-scan-on-hbase-faster-if-running-hbase-on-more-than-1-machine?rq=1
>
> Thanks,
>
>> From: anilgupta84@gmail.com
>> Date: Sat, 17 Nov 2012 16:51:31 -0800
>> Subject: Re: Hive and Hbase performance
>> To: user@hbase.apache.org
>>
>> Hi Dalia,
>>
>> The usual and short answer is Yes. Both, HBase and Hive will provide better
>> performance on adding more nodes since they provide horizontal scalability.
>>
>> HTH,
>> Anil
>>
>>
>>
>> On Sat, Nov 17, 2012 at 4:02 PM, Dalia Sobhy <da...@hotmail.com>wrote:
>>
>>>
>>> I want to ask if a Hive Count or Scan Query will provide better
>>> performance when adding more nodes ??
>>>
>>> if an Hbase Count or Scan Query will provide better performance when
>>> adding more nodes ??
>>
>>
>>
>>
>> --
>> Thanks & Regards,
>> Anil Gupta
>
RE: Hive and Hbase performance
Posted by Dalia Sobhy <da...@hotmail.com>.
Hi Anil,
I thought so, but when checking this blog I got confused, Could u check it and give me your feedback?
http://stackoverflow.com/questions/9300840/is-running-scan-on-hbase-faster-if-running-hbase-on-more-than-1-machine?rq=1
Thanks,
> From: anilgupta84@gmail.com
> Date: Sat, 17 Nov 2012 16:51:31 -0800
> Subject: Re: Hive and Hbase performance
> To: user@hbase.apache.org
>
> Hi Dalia,
>
> The usual and short answer is Yes. Both, HBase and Hive will provide better
> performance on adding more nodes since they provide horizontal scalability.
>
> HTH,
> Anil
>
>
>
> On Sat, Nov 17, 2012 at 4:02 PM, Dalia Sobhy <da...@hotmail.com>wrote:
>
> >
> > I want to ask if a Hive Count or Scan Query will provide better
> > performance when adding more nodes ??
> >
> > if an Hbase Count or Scan Query will provide better performance when
> > adding more nodes ??
> >
>
>
>
>
> --
> Thanks & Regards,
> Anil Gupta
Re: Hive and Hbase performance
Posted by anil gupta <an...@gmail.com>.
Hi Dalia,
The usual and short answer is Yes. Both, HBase and Hive will provide better
performance on adding more nodes since they provide horizontal scalability.
HTH,
Anil
On Sat, Nov 17, 2012 at 4:02 PM, Dalia Sobhy <da...@hotmail.com>wrote:
>
> I want to ask if a Hive Count or Scan Query will provide better
> performance when adding more nodes ??
>
> if an Hbase Count or Scan Query will provide better performance when
> adding more nodes ??
>
--
Thanks & Regards,
Anil Gupta