You are viewing a plain text version of this content. The canonical link for it is here.
Posted to mapreduce-user@hadoop.apache.org by iwannaplay games <fu...@gmail.com> on 2012/10/18 12:40:44 UTC
Comparison of hbase/hadoop with sql server
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
Re: Comparison of hbase/hadoop with sql server
Posted by iwannaplay games <fu...@gmail.com>.
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 <ha...@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
> <fu...@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
>
Re: Comparison of hbase/hadoop with sql server
Posted by iwannaplay games <fu...@gmail.com>.
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 <ha...@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
> <fu...@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
>
Re: Comparison of hbase/hadoop with sql server
Posted by iwannaplay games <fu...@gmail.com>.
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 <ha...@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
> <fu...@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
>
Re: Comparison of hbase/hadoop with sql server
Posted by iwannaplay games <fu...@gmail.com>.
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 <ha...@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
> <fu...@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
>
unsubscribe
Posted by David Pavlis <da...@javlin.eu>.
Unsubscribe
unsubscribe
Posted by David Pavlis <da...@javlin.eu>.
Unsubscribe
unsubscribe
Posted by David Pavlis <da...@javlin.eu>.
Unsubscribe
unsubscribe
Posted by David Pavlis <da...@javlin.eu>.
Unsubscribe
Re: Comparison of hbase/hadoop with sql server
Posted by Harsh J <ha...@cloudera.com>.
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
<fu...@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
Re: Comparison of hbase/hadoop with sql server
Posted by Harsh J <ha...@cloudera.com>.
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
<fu...@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
Re: Comparison of hbase/hadoop with sql server
Posted by Harsh J <ha...@cloudera.com>.
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
<fu...@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
Re: Comparison of hbase/hadoop with sql server
Posted by Harsh J <ha...@cloudera.com>.
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
<fu...@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
Re: Comparison of hbase/hadoop with sql server
Posted by Harsh J <ha...@cloudera.com>.
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
<fu...@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
Comparison of hbase/hadoop with sql server
Posted by iwannaplay games <fu...@gmail.com>.
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
Comparison of hbase/hadoop with sql server
Posted by iwannaplay games <fu...@gmail.com>.
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
Comparison of hbase/hadoop with sql server
Posted by iwannaplay games <fu...@gmail.com>.
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
Comparison of hbase/hadoop with sql server
Posted by iwannaplay games <fu...@gmail.com>.
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
Comparison of hbase/hadoop with sql server
Posted by iwannaplay games <fu...@gmail.com>.
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