Re: HBase aggregate query
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 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
Re: HBase UI missing region list for active/functioning table
It scans .META. table just like any other table. I just tested it and it produced the expected output. Thanks, Srinivas M On Sep 10, 2012 12:19 PM, Stack st...@duboce.net wrote: On Mon, Sep 10, 2012 at 8:33 AM, Norbert Burger norbert.bur...@gmail.com wrote: Hi all -- we're currently on cdh3u3 (0.90.4 + patches). I have one table in our cluster which seems to functioning fine (gets/puts/scans are all working), but for which no regions are listed on the UI. The table/regions exist in .META. Other tables in the same cluster show their regions list fine. Seems like this might be a problem with .META. or ZK, but would appreciate any pointers. 1) hbase hbck reports 2 multiply assigned to region servers inconsistencies, but on a table different than the one I'm having problems with. 2) The hbase master log shows this fragment when navigating to table.jsp for the affected table: 2012-09-10 11:29:07,682 DEBUG org.apache.zookeeper.ClientCnxn: Reading reply sessionid:0x1370e3604c49580, packet:: clientPath:null serverPath:null finished:false header:: 10,4 replyHeader:: 10,167713215,-101 request:: '/hbase/table/sessions,F response:: 2012-09-10 11:29:07,682 DEBUG org.apache.hadoop.hbase.zookeeper.ZKUtil: hconnection-0x1370e3604c49580 Unable to get data of znode /hbase/table/sessions because node does not exist (not an error) 2012-09-10 11:29:07,682 DEBUG org.apache.hadoop.hbase.client.MetaScanner: Scanning .META. starting at row=sessions,,00 for max=2147483647 rows But since I see this Unable to get data of znode for all tables, my assumption is that it's a red herring. Any thoughts as how to debug further, or why only this table would not show a region list? What happens if you scan .META. in shell? hbase scan .META. Does it all show? (You might want to echo into a file so you can poke around after scan is done). St.Ack
Re: 答复: for CDH4.0, where can i find the hbase-default.xml file if using RPM install
I just installed HBase from .tar.gz file and I couldn't find that file either. Thanks, Srinivas M On Sep 10, 2012 11:03 AM, huaxiang huaxi...@asiainfo-linkage.com wrote: Hi, I don't find the hbase-default.xml file using following command, any other way? To be clear, this hadoop was installed with CDH RPM package. Huaxiang [root@hadoop1 ~]# clear [root@hadoop1 ~]# rpm -qlp *rpm_file_name.rpm* [root@hadoop1 ~]# ^C [root@hadoop1 ~]# find / -name *hbase-default.xml* /usr/share/doc/hbase-0.92.1+67/hbase-default.xml [root@hadoop1 ~]# -邮件原件- 发件人: Monish r [mailto:monishs...@gmail.com] 发送时间: 2012年9月10日 15:00 收件人: user@hbase.apache.org 主题: Re: for CDH4.0, where can i find the hbase-default.xml file if using RPM install Hi, Try rpm -qlp *rpm_file_name.rpm* This will list all files in the rpm , from this u can know where hbase-default.xml is. On Sat, Sep 8, 2012 at 3:16 PM, John Hancock jhancock1...@gmail.com wrote: Huaxiang, This may not be the quickest way to find it, but if it's anywhere in your system, this command will find it: find / -name *hbase-default.xml* or cd / find / -name *hbase-default.xml* temp.txt will save the output of the find command to a text file leaving out any error messages that might be distracting. -John On Sat, Sep 8, 2012 at 12:47 AM, huaxiang huaxi...@asiainfo-linkage.com wrote: Hi, I install CDH4.0 with RPM package, but I cannot find the hbase-default.xml file? Where can I find it? Best R. Huaxiang