Hi, Could you please explain the reason for the behavior?
Regards, Biju On Tue, Mar 8, 2011 at 11:35 AM, John Sichi <jsi...@fb.com> wrote: > Yes. > > JVS > > On Mar 7, 2011, at 9:59 PM, Biju Kaimal wrote: > > > Hi, > > > > I loaded a data set which has 1 million rows into both Hive and HBase > tables. For the HBase table, I created a corresponding Hive table so that > the data in HBase can be queried from Hive QL. Both tables have a key column > and a value column > > > > For the same query (select value, count(*) from table group by value), > the Hive only query runs much faster (~ 30 seconds) as compared to Hive over > HBase (~ 150 seconds). > > > > Is this expected? > > > > Regards, > > Biju > >
