We haven't done thorough performance comparison recently apart from what is listed on Phoenix performance<http://phoenix.incubator.apache.org/performance.html> page. For Shark, let me see if I can find basic number that we tried about a year back. On top of my head what I can recall is that Shark was faster only for small in-memory tables when compared to Phoenix, for standard tables, Phoenix was much much faster.
On Thu, Mar 27, 2014 at 12:17 PM, Localhost shell < [email protected]> wrote: > Thanks for the quick response. > > Is there any Hive Vs Impala Vs Shark or other tools performance comparison? > > I am trying to convince folks in my project to use Hbase-Phoenix > combination. I understand the optimizations done by phoenix by using > coprocessors and custom filters. > Hence these performance graphs will help me build a more convincing > argument. > > > > On Thu, Mar 27, 2014 at 10:50 AM, Mujtaba Chohan <[email protected]>wrote: > >> Hi Harshit, >> >> Take a look at this. This compares Phoenix 2.2.3 against latest 3.0.0-RC >> and 4.0.0-RC using various schema tables. >> http://phoenix-bin.github.io/client/performance/phoenix-20140324122633.htm >> >> //Mujtaba >> >> >> On Thu, Mar 27, 2014 at 10:46 AM, Localhost shell < >> [email protected]> wrote: >> >>> Hey All, >>> >>> I couldn't find the performance comparison graphs on the apache site. >>> I found few at info at >>> https://github.com/forcedotcom/phoenix/wiki/Performance but it's quite >>> old and also the data and nature of query is also very basic. >>> >>> Query: select count(1) from table over 1M and 5M rows. Data is 3 narrow >>> columns. Number of Region Server: 1 (Virtual Machine, HBase heap: 2GB, >>> Processor: 2 cores @ 3.3GHz Xeon) >>> >>> Can anyone point me to some more concrete performance number if >>> available? >>> >>> --Harshit >>> >> >> >
