Hi there, if there are common questions I'd suggest creating summary tables of the pre-aggregated results.
http://hbase.apache.org/book.html#mapreduce.example 7.2.4. HBase MapReduce Summary to HBase Example On 9/10/12 10:03 AM, "iwannaplay games" <funnlearnfork...@gmail.com> wrote: >Hi , > >I want to run query like > >select month(eventdate),scene,count(1),sum(timespent) from eventlog >group by month(eventdate),scene > > >in hbase.Through hive its taking a lot of time for 40 million >records.Do we have any syntax in hbase to find its result?In sql >server it takes around 9 minutes,How long it might take in hbase?? > >Regards >Prabhjot >