Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (athena.apache.org: domain of funnlearnforkids@gmail.com
 designates 209.85.223.169 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CALte62wpXOfMQ3K+Eb88GXWvJmLgax8x7-Vovo76G4R=VX18yQ@mail.gmail.com>
References: 
 <CAH-_ydjHa7EPCF6b9v6y6RH+YrG9CGvMW1B=qmEcPwN+5E135g@mail.gmail.com>
	<CALte62wpXOfMQ3K+Eb88GXWvJmLgax8x7-Vovo76G4R=VX18yQ@mail.gmail.com>
Date: Mon, 10 Sep 2012 19:52:48 +0530
Message-ID: 
 <CAH-_ydgVjkd69f5WUH+=46Hg68oWyBGsAt5oVX_AF2tQhKu_fA@mail.gmail.com>
Subject: Re: HBase aggregate query
From: iwannaplay games <funnlearnforkids@gmail.com>
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=bcaec555510031d90904c959b12b

--bcaec555510031d90904c959b12b
Content-Type: text/plain; charset=ISO-8859-1

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
> >
>

--bcaec555510031d90904c959b12b--