than SQL Server for such a small data set.
- Original Message -
From: James Taylorjtay...@salesforce.com
To: user@hbase.apache.org
Cc:
Sent: Monday, September 10, 2012 5:49 PM
Subject: Re: HBase aggregate query
iwannaplay gamesfunnlearnforkids@... writes:
Hi ,
I want to run query like
iwannaplay games funnlearnforkids@... writes:
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
To: user@hbase.apache.org
Cc:
Sent: Monday, September 10, 2012 5:49 PM
Subject: Re: HBase aggregate query
iwannaplay games funnlearnforkids@... writes:
Hi ,
I want to run query like
select month(eventdate),scene,count(1),sum(timespent) from eventlog
group by month(eventdate),scene
it will
probably be slower than SQL Server for such a small data set.
- Original Message -
From: James Taylor jtay...@salesforce.com
To: user@hbase.apache.org
Cc:
Sent: Monday, September 10, 2012 5:49 PM
Subject: Re: HBase aggregate query
iwannaplay games funnlearnforkids@... writes:
Hi
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
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
HBase only provides CRUD operations by means of Put/Get/Delete API and
there is no built in SQL interface.
Thanks,
Srinivas M
On Sep 10, 2012 9:03 AM, iwannaplay games funnlearnfork...@gmail.com
wrote:
Hi ,
I want to run query like
select month(eventdate),scene,count(1),sum(timespent) from
its taking very long
On Mon, Sep 10, 2012 at 7:34 PM, Ted Yu yuzhih...@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
funnlearnfork...@gmail.com wrote:
Hi ,
I want to run query like
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