hadoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From iwannaplay games <funnlearnfork...@gmail.com>
Subject Re: Comparison of hbase/hadoop with sql server
Date Thu, 18 Oct 2012 11:54:55 GMT
Ohh i am so sorry its hadoop +hive,hbase and sql server query performance
for
Comparison for 20 billion records aggregate query u can say for eg

select month,department,count(employee),sum(salary)
from company table
group by month,department



On Thu, Oct 18, 2012 at 5:10 PM, Harsh J <harsh@cloudera.com> wrote:

> What is the difference between HBase and Hadoop+HBase? HBase runs on
> top of Hadoop components.
>
> Also, first answer us this question, before we answer yours: Will your
> "SQL Server" scale linearly as you add more machines? Can it easily
> scale horizontally and vertically?
>
> Seems to me like you're comparing the wrong elements in deciding what
> platform to base your application on. If you could explain what you
> wish to do, and what data sizes you expect to work with, we can
> provide a better answer.
>
> On Thu, Oct 18, 2012 at 5:06 PM, iwannaplay games
> <funnlearnforkids@gmail.com> wrote:
> > Hi,
> >
> > Can anyone give the clear idea about these comparisons on same hardware &
> > software configuration.
> >
> >                                                          Sql server
> > hbase        hadoop+hbase
> > data compression                                     ?
> > ?                    ?                              (yes/no,if all yes
> > where it is more effective)
> > Online back ups                                        ?
> > ?                   ?
> > Security                                                   ?
> > ?                     ?                       (which is more secure and
> > more controllable)
> > Batch Queries execution time                    ?
> > ?                     ?                           (where time consumption
> > will b more for aggregates)
> >
> >
> > Let me know if i need to consider any benefit of hadoop/hbase over sql
> > server
> >
> > Thanks & Regards
> > Prabhjot
>
>
>
> --
> Harsh J
>

Mime
View raw message