hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From iwannaplay games <funnlearnfork...@gmail.com>
Subject Re: HBase aggregate query
Date Mon, 10 Sep 2012 14:22:48 GMT
its taking very long

On Mon, Sep 10, 2012 at 7:34 PM, Ted Yu <yuzhihong@gmail.com> wrote:

> Hi,
> Are you able to get the number you want through hive log ?
>
> Thanks
>
> On Mon, Sep 10, 2012 at 7:03 AM, iwannaplay games <
> funnlearnforkids@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
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message