Re: HBase aggregate query

2012-09-13 Thread James Taylor
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

Re: HBase aggregate query

2012-09-11 Thread James Taylor
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

Re: HBase aggregate query

2012-09-11 Thread lars hofhansl
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

Re: HBase aggregate query

2012-09-11 Thread Jerry Lam
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

Re: HBase aggregate query

2012-09-10 Thread Ted Yu
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

Re: HBase aggregate query

2012-09-10 Thread Srinivas Mupparapu
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

Re: HBase aggregate query

2012-09-10 Thread iwannaplay games
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

Re: HBase aggregate query

2012-09-10 Thread Doug Meil
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