Re: Hive performance vs. SQL?

2012-03-19 Thread Keith Wiley
Thanks for the response. Cheers! On Mar 19, 2012, at 16:42 , Maxime Brugidou wrote: > From my experience, if you can fit data in a SQL without sharding or > anything, don't ever think twice. Hive is not even comparable. _

Re: Hive performance vs. SQL?

2012-03-19 Thread Maxime Brugidou
>From my experience, if you can fit data in a SQL without sharding or anything, don't ever think twice. Hive is not even comparable. I would rather say that Hive is a nice SQL interface over Hadoop M/R rather than any SQL replacement. If you are running a DWH in SQL and you don't need to grow your

Hive performance vs. SQL?

2012-03-19 Thread Keith Wiley
I haven't had an opportunity to set up a huge Hive database yet because exporting csv files from our SQL database is, in itself, a rather laborious task. I was just curious how I might expect Hive to perform vs. SQL on large databases and large queries? I realize Hive is pretty "latent" since