Re: querying hbase

2013-05-22 Thread Ian Varley
Thanks for those links JM - hadn't seen any of those before. I think it's useful to have stuff like this, for new users to explore using HBase. Re: Phoenix, I don't think it's fundamentally any more involved than any of those, it's just a library. It exposes a JDBC driver interface, so GUI

AW: ETL tools

2013-05-22 Thread Ismail.Abdelnabi
Hello, you can use Pentaho Data Integration that handles different types of sources. -Ursprüngliche Nachricht- Von: Aji Janis [mailto:aji1...@gmail.com] Gesendet: Dienstag, 21. Mai 2013 23:02 An: user@hbase.apache.org Betreff: ETL tools Hello users, I am interested in hearing about

Unknown process in listing of jps command

2013-05-22 Thread Vimal Jain
Hi, I have configured Hadoop and Hbase successfully ( i think so ) . I tried creating some tables and it works fine. When i issue jps command to list java processes , i see following :- hadoop@Rupesh:~/HadoopBase$ jps *16276 Main 13594 NameNode 14033 SecondaryNameNode 15643 HQuorumPeer 13812

Not able to connect to Hbase remotly

2013-05-22 Thread Vimal Jain
Hi, I have Hbase configured in pseudo distributed mode on Machine A. I would like to connect to it through a Java program running on Machine B. But i am unable to do so.What configurations are required in Java for this ? Please help. -- Thanks and Regards, Vimal Jain

RE: Not able to connect to Hbase remotly

2013-05-22 Thread Jyothi Mandava
Hi, How are you trying to connect? Are you setting zookeeper host and client port in HBaseConfiguration? Regards, Jyothi -Original Message- From: Vimal Jain [mailto:vkj...@gmail.com] Sent: 22 May 2013 14:57 To: user@hbase.apache.org Subject: Not able to connect to Hbase remotly Hi, I

Re: Not able to connect to Hbase remotly

2013-05-22 Thread Vimal Jain
Hi, Yes Jyothi. Here is my Java code Configuration config = HBaseConfiguration.create(); config.set(hbase.zookeeper.quorum ,192.168.0.181); config.set(hbase.zookeeper.property.clientPort,2181); tablePool = new HTablePool(config,Integer.MAX_VALUE);

RE: Not able to connect to Hbase remotly

2013-05-22 Thread Jyothi Mandava
Hi, Code seem to be fine. Getting any exceptions at client side? Does your client machine hosts file has an entry for 192.168.0.181? Both machines able to access each other? Regards, Jyothi -Original Message- From: Vimal Jain [mailto:vkj...@gmail.com] Sent: 22 May 2013 15:18 To:

Re: Not able to connect to Hbase remotly

2013-05-22 Thread Vimal Jain
No exception at client side . Code just hangs on call to htablepool.getTable(tableName) In zookeeper logs , i am able to see that it received a request for connection from Java program but it did not proceed ahead. Any reason to add 192.168.0.181 in /etc/hosts , because as per my understanding

RE: Not able to connect to Hbase remotly

2013-05-22 Thread Jyothi Mandava
Connection between master and zookeeper are ok? Have you verified if your cluster is working fine (zookeeper to master connection)? I had connection issue though the IP was set in configuration and connection was tried with host. Adding hosts entry resolved the issue. But no errors at client in

Re: Not able to connect to Hbase remotly

2013-05-22 Thread Vimal Jain
Hi Jyothi, I am running my hbase in pseudo distributed mode so zookeeper and master are on same machine. On Wed, May 22, 2013 at 4:28 PM, Jyothi Mandava jyothi.mand...@huawei.comwrote: Connection between master and zookeeper are ok? Have you verified if your cluster is working fine

Re: Not able to connect to Hbase remotly

2013-05-22 Thread Mohammad Tariq
Hello Vimal, Add the IP and hostname of your HBase machine into the hosts file of your client machine and see if it helps. Warm Regards, Tariq cloudfront.blogspot.com On Wed, May 22, 2013 at 4:38 PM, Vimal Jain vkj...@gmail.com wrote: Hi Jyothi, I am running my hbase in pseudo

Re: Unknown process in listing of jps command

2013-05-22 Thread Mohammad Tariq
Hello VImal, HQuorumPeer=ZK Main=Eclipse or something(i feel) Warm Regards, Tariq cloudfront.blogspot.com On Wed, May 22, 2013 at 2:01 PM, Vimal Jain vkj...@gmail.com wrote: Hi, I have configured Hadoop and Hbase successfully ( i think so ) . I tried creating some tables and

Re: Unknown process in listing of jps command

2013-05-22 Thread Vimal Jain
Ok.Thanks Tariq. On Wed, May 22, 2013 at 4:43 PM, Mohammad Tariq donta...@gmail.com wrote: Hello VImal, HQuorumPeer=ZK Main=Eclipse or something(i feel) Warm Regards, Tariq cloudfront.blogspot.com On Wed, May 22, 2013 at 2:01 PM, Vimal Jain vkj...@gmail.com wrote:

Re: Not able to connect to Hbase remotly

2013-05-22 Thread Vimal Jain
Hi Tariq, I tried this but its not helping. Let me brief you about the problem. I have posted this on http://stackoverflow.com/questions/16689594/unable-to-connect-to-hbase-remotly Please help. On Wed, May 22, 2013 at 4:41 PM, Mohammad Tariq donta...@gmail.com wrote: Hello Vimal, Add

RE: Not able to connect to Hbase remotly

2013-05-22 Thread Jyothi Mandava
Is the cluster ok? Have you tried creating table or any other operation using Shell where master is involved? Do you see anything in Master logs? Pls share your ZK log ( and master if there is any useful info). Regards, Jyothi. -Original Message- From: Vimal Jain

Re: Not able to connect to Hbase remotly

2013-05-22 Thread Vimal Jain
Yes. I tried creating some tables , and it works fine. I have attached my master and zookeeper logs. On Wed, May 22, 2013 at 5:11 PM, Jyothi Mandava jyothi.mand...@huawei.comwrote: Is the cluster ok? Have you tried creating table or any other operation using Shell where master is involved?

RE: Not able to connect to Hbase remotly

2013-05-22 Thread Jyothi Mandava
Could not find the logs. From: Vimal Jain [mailto:vkj...@gmail.com] Sent: 22 May 2013 17:18 To: user@hbase.apache.org Subject: Re: Not able to connect to Hbase remotly Yes. I tried creating some tables , and it works fine. I have attached my master and zookeeper logs. On Wed, May 22, 2013 at

Re: Not able to connect to Hbase remotly

2013-05-22 Thread Vimal Jain
I had attached it.May be attachments are blocked. Attachments are big.How do i send it ? On Wed, May 22, 2013 at 5:47 PM, Jyothi Mandava jyothi.mand...@huawei.comwrote: Could not find the logs. From: Vimal Jain [mailto:vkj...@gmail.com] Sent: 22 May 2013 17:18 To: user@hbase.apache.org

Re: Not able to connect to Hbase remotly

2013-05-22 Thread Vimal Jain
Hi, I got below Runtime exception after i changed my catch block ( from catch(IOException) to catch(Exception) ). Sorry for trouble. Exception : org.apache.hadoop.hbase.client.NoServerForRegionException: Unable to find region for event_data where event_data is the table i have created in Hbase

Risk about RS logs clean ?

2013-05-22 Thread Bing Jiang
Hi,all I want to know how RS eliminates the unnecessary hlogs. lastSeqNum stores RegionName, latest KV Seq id and outputfiles stores last Seq id before new hlog file, file path So, how does rs guarantee that the kv in the hlog to be cleared have been already flushed from memstore into hfile. I

Re: querying hbase

2013-05-22 Thread Shahab Yunus
Hi, Just writing to say thanks folks (Jean-Marc Lars)! I didn't know about these tools and H-rider is so useful and easy to use. Regards, Shahab On Tue, May 21, 2013 at 11:41 PM, Jean-Marc Spaggiari jean-m...@spaggiari.org wrote: Using Phoenix for that is like trying to kill a mosquito with

Re: Not able to connect to Hbase remotly

2013-05-22 Thread Vimal Jain
Thanks Tariq and Jyothi for your help. I have solved this issue but not sure which step did the trick. I 1) changed configuration files ( Hadoop and Hbase both ) and replaced hostnames with ip addresses. 2) played with /etc/hosts a bit 3) restarted hadoop and hbase several times .. Thanks again.

Re: Inconsistent Table HBCK

2013-05-22 Thread Jay Talreja
*0.94.0* The issue (I think) was related to a region split that didn't happen cleanly. As a result there were references to daughter region present in HDFS. I believe the -fixSplitParents would have taken care of this but it is not available in 0.94.0 I manually deleted reference files from

Re: querying hbase

2013-05-22 Thread Aji Janis
These tools seem just like what I want! Thank you. I am trying to play with it now but looks like in our Hbase configuration HBASE_MANAGE_ZK is set to False in hbase-env and hbase.zookeeper.property.clientPort is not set in hbase-site and therefore I can't use hbasemanager or hrider. I am new to

Re: Inconsistent Table HBCK

2013-05-22 Thread Jean-Marc Spaggiari
Thanks for the feedback Jay. I helped someone who faced the same issue recently. Might deserve a fix... (and so a JIRA with details) Also, I would recommend you to migrate to a sooner 0.94.x version. JM 2013/5/22 Jay Talreja jay.talr...@oracle.com *0.94.0* The issue (I think) was related

Re: HBase is not running.

2013-05-22 Thread Yves S. Garret
Still stuck on this. I did something different, I tried version 0.92.2. This is the log from that older version. http://bin.cakephp.org/view/617939270 The other weird thing that I noticed with version on 0.92.2 is this. I started HBase and this is the output that I got: $

Re: PleaseHoldException when Master is clearly running as JPS

2013-05-22 Thread Jay Vyas
Okay I finally fixed and the problem... The reason it took long is because it's tricky to know if hmaster is failing due to network errors vs file system or other lower level errors. In my case, it was failing because of both, and i was just restarting the master, which masked the error

Re: querying hbase

2013-05-22 Thread James Taylor
Hey JM, Can you expand on what you mean? Phoenix is a single jar, easily deployed to any HBase cluster. It can map to existing HBase tables or create new ones. It allows you to use SQL (a fairly popular language) to query your data, and it surfaces it's functionality as a JDBC driver so that

Re: querying hbase

2013-05-22 Thread James Taylor
Hi Aji, With Phoenix, you pass through the client port in your connection string, so this would not be an issue. If you're familiar with SQL Developer, then Phoenix supports something similar with SQuirrel: https://github.com/forcedotcom/phoenix#sql-client Regards, James On 05/22/2013 07:42

Re: Risk about RS logs clean ?

2013-05-22 Thread Sergey Shelukhin
FSHLog (in trunk) stores the earliest seqnums for each region in current memstore, and earliest flushing seqnum (see FSHLog::start/complete/abortCacheFlush). When logs are deleted the logs with seqnums that are above the earliest flushing/flushed seqnum for any region are not deleted (see

Simple but Reliable configuration for pseudo distributed mode on ubuntu

2013-05-22 Thread Stephen Boesch
I have not been able to bring up a simple standalone hbase pseuo distributed mode cluster on a single ubuntu 12.x machine. A couple of co-workers that have been using hbase for years also looked at it and we have not been able to resolve. Before I jump in to the details, i'll just say : hey is

Re: Simple but Reliable configuration for pseudo distributed mode on ubuntu

2013-05-22 Thread Stephen Boesch
OK found the issue, it was the old ubuntu localhost anomaly of 127.0.1.1 vs 127.0.0.1 Changing /etc/hosts to use the latter fixed the issue Here is the quick start reference to it http://hbase.apache.org/book/quickstart.html Loopback IP HBase expects the loopback IP address to be 127.0.0.1.

Re: Simple but Reliable configuration for pseudo distributed mode on ubuntu

2013-05-22 Thread Jay Vyas
clearly there is a very high coupling to the /etc/hosts file in hbase. Is this necessary? On Wed, May 22, 2013 at 3:46 PM, Stephen Boesch java...@gmail.com wrote: OK found the issue, it was the old ubuntu localhost anomaly of 127.0.1.1 vs 127.0.0.1 Changing /etc/hosts to use the latter

Re: HBase is not running.

2013-05-22 Thread Yves S. Garret
How does Zookeeper fit into this picture? For hbase.zookeeper.quorum, I have it set to localhost. Would I need to include Zookeeper or start it up in some way in order to get it to run? On Wed, May 22, 2013 at 1:44 PM, Jay Vyas jayunit...@gmail.com wrote: Yves, im going through the same

Re: Poor HBase map-reduce scan performance

2013-05-22 Thread Sandy Pratt
I found this thread on search-hadoop.com just now because I've been wrestling with the same issue for a while and have as yet been unable to solve it. However, I think I have an idea of the problem. My theory is based on assumptions about what's going on in HBase and HDFS internally, so please

Re: RS crash upon replication

2013-05-22 Thread Varun Sharma
Basically, You had va-p-hbase-02 crash - that caused all the replication related data in zookeeper to be moved to va-p-hbase-01 and have it take over for replicating 02's logs. Now each region server also maintains an in-memory state of whats in ZK, it seems like when you start up 01, its trying

Re: Poor HBase map-reduce scan performance

2013-05-22 Thread Ted Yu
Sandy: Do you think the following JIRA would help with what you expect in this regard ? HBASE-8420 Port HBASE-6874 Implement prefetching for scanners from 0.89-fb Cheers On Wed, May 22, 2013 at 1:29 PM, Sandy Pratt prat...@adobe.com wrote: I found this thread on search-hadoop.com just now

Re: RS crash upon replication

2013-05-22 Thread Varun Sharma
Also what version of HBase are you running ? On Wed, May 22, 2013 at 1:38 PM, Varun Sharma va...@pinterest.com wrote: Basically, You had va-p-hbase-02 crash - that caused all the replication related data in zookeeper to be moved to va-p-hbase-01 and have it take over for replicating 02's

Re: RS crash upon replication

2013-05-22 Thread amit.mor.m...@gmail.com
ls /hbase/replication/rs/va-p-hbase-01-c,60020,1369249873379 [1] [zk: va-p-zookeeper-01-c:2181(CONNECTED) 2] ls /hbase/replication/rs/va-p-hbase-01-c,60020,1369249873379/1 [] I'm on hbase-0.94.2-cdh4.2.1 Thanks On Wed, May 22, 2013 at 11:40 PM, Varun Sharma va...@pinterest.com wrote: Also

Re: RS crash upon replication

2013-05-22 Thread Ted Yu
What does this command show you ? get /hbase/replication/rs/va-p-hbase-01-c,60020,1369249873379/1 Cheers On Wed, May 22, 2013 at 1:46 PM, amit.mor.m...@gmail.com amit.mor.m...@gmail.com wrote: ls /hbase/replication/rs/va-p-hbase-01-c,60020,1369249873379 [1] [zk:

Re: RS crash upon replication

2013-05-22 Thread amit.mor.m...@gmail.com
[zk: va-p-zookeeper-01-c:2181(CONNECTED) 3] get /hbase/replication/rs/va-p-hbase-01-c,60020,1369249873379/1 cZxid = 0x60281c1de ctime = Wed May 22 15:11:17 EDT 2013 mZxid = 0x60281c1de mtime = Wed May 22 15:11:17 EDT 2013 pZxid = 0x60281c1de cversion = 0 dataVersion = 0 aclVersion = 0

Re: RS crash upon replication

2013-05-22 Thread Varun Sharma
Do an ls not a get here and give the output ? ls /hbase/replication/rs/va-p-hbase-01-c,60020,1369249873379/1 On Wed, May 22, 2013 at 1:53 PM, amit.mor.m...@gmail.com amit.mor.m...@gmail.com wrote: [zk: va-p-zookeeper-01-c:2181(CONNECTED) 3] get

Re: RS crash upon replication

2013-05-22 Thread Amit Mor
empty return: [zk: va-p-zookeeper-01-c:2181(CONNECTED) 10] ls /hbase/replication/rs/va-p-hbase-01-c,60020,1369249873379/1 [] On Thu, May 23, 2013 at 12:05 AM, Varun Sharma va...@pinterest.com wrote: Do an ls not a get here and give the output ? ls

Re: Simple but Reliable configuration for pseudo distributed mode on ubuntu

2013-05-22 Thread Stack
How could we improve the doc Stephen? Was the problem that it was only in the quick start section? Thanks. St.Ack On Wed, May 22, 2013 at 12:46 PM, Stephen Boesch java...@gmail.com wrote: OK found the issue, it was the old ubuntu localhost anomaly of 127.0.1.1 vs 127.0.0.1 Changing

Re: Simple but Reliable configuration for pseudo distributed mode on ubuntu

2013-05-22 Thread Stack
What did the logs show regards who could not find who? (I would like to answer Jay Vyas but thought I'd ask here first to see if could see what tight-coupling to /etc/hosts we are guilty of). Thanks, St.Ack On Wed, May 22, 2013 at 12:46 PM, Stephen Boesch java...@gmail.com wrote: OK found the

Re: RS crash upon replication

2013-05-22 Thread Amit Mor
I found this: [zk: va-p-zookeeper-01-c:2181(CONNECTED) 17] ls /hbase/replication/rs/va-p-hbase-02-d,60020,1369249862401 [1-va-p-hbase-02-e,60020,1369042377129-va-p-hbase-02-c,60020,1369042377731-va-p-hbase-02-d,60020,1369233252475,

Re: RS crash upon replication

2013-05-22 Thread Varun Sharma
2013-05-22 15:31:25,929 WARN org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper: Possibly transient ZooKeeper exception: org.apache.zookeeper.KeeperException$SessionExpiredException: KeeperErrorCode = Session expired for *

Re: RS crash upon replication

2013-05-22 Thread Varun Sharma
I see - so looks okay - there's just a lot of deep nesting in there - if you look into these you nodes by doing ls - you should see a bunch of WAL(s) which still need to be replicated... Varun On Wed, May 22, 2013 at 2:16 PM, Varun Sharma va...@pinterest.com wrote: 2013-05-22 15:31:25,929

Re: RS crash upon replication

2013-05-22 Thread Varun Sharma
Can you do ls /hbase/rs and see what you get for 02-d - instead of looking in /replication/, could you look in /hbase/replication/rs - I want to see if the timestamps are matching or not ? Varun On Wed, May 22, 2013 at 2:17 PM, Varun Sharma va...@pinterest.com wrote: I see - so looks okay -

Re: RS crash upon replication

2013-05-22 Thread Varun Sharma
Basically ls /hbase/rs and what do you see for va-p-02-d ? On Wed, May 22, 2013 at 2:19 PM, Varun Sharma va...@pinterest.com wrote: Can you do ls /hbase/rs and see what you get for 02-d - instead of looking in /replication/, could you look in /hbase/replication/rs - I want to see if the

Re: RS crash upon replication

2013-05-22 Thread Amit Mor
va-p-hbase-02-d,60020,1369249862401 On Thu, May 23, 2013 at 12:20 AM, Varun Sharma va...@pinterest.com wrote: Basically ls /hbase/rs and what do you see for va-p-02-d ? On Wed, May 22, 2013 at 2:19 PM, Varun Sharma va...@pinterest.com wrote: Can you do ls /hbase/rs and see what you

Re: RS crash upon replication

2013-05-22 Thread Varun Sharma
I believe there were cascading failures which got these deep nodes containing still to be replicated WAL(s) - I suspect there is either some parsing bug or something which is causing the replication source to not work - also which version are you using - does it have

Re: RS crash upon replication

2013-05-22 Thread Amit Mor
yes, indeed - hyphens are part of the host name (annoying legacy stuff in my company). It's hbase-0.94.2-cdh4.2.1. I have no idea if 0.94.6 was backported by Cloudera into their flavor of 0.94.2, but the mysterious occurrence of the percent sign in zkcli (ls

Re: Simple but Reliable configuration for pseudo distributed mode on ubuntu

2013-05-22 Thread Stephen Boesch
Hi Stack, This section of the docs is clear. I would suggest it should be included in *all *docs not just the standalone section. I had seen that section of the docs before, and it was on my mind.. I had made the change from 127.0.1.1 to 127.0.0.1 in the past and it had not worked -but I had

Re: RS crash upon replication

2013-05-22 Thread Amit Mor
Yes, I have checked the source files of the 0.94.2-cdh4.2.1 jar and HBASE-8207 issues are present in the source codes, namely: String[] parts = peerClusterZnode.split(-); On Thu, May 23, 2013 at 12:42 AM, Amit Mor amit.mor.m...@gmail.com wrote: yes, indeed - hyphens are part of the host name

Re: RS crash upon replication

2013-05-22 Thread Himanshu Vashishtha
I'd suggest to please patch the code with 8207; cdh4.2.1 doesn't have it. With hyphens in the name, ReplicationSource gets confused and tried to set data in a znode which doesn't exist. Thanks, Himanshu On Wed, May 22, 2013 at 2:42 PM, Amit Mor amit.mor.m...@gmail.com wrote: yes, indeed -

Re: Poor HBase map-reduce scan performance

2013-05-22 Thread Sandy Pratt
It seems to be in the ballpark of what I was getting at, but I haven't fully digested the code yet, so I can't say for sure. Here's what I'm getting at. Looking at o.a.h.h.client.ClientScanner.next() in the 94.2 source I have loaded, I see there are three branches with respect to the cache:

RE: Inconsistent Table HBCK

2013-05-22 Thread Tianying Chang
Hi, Jean What is the jira #? Thanks Tian-Ying -Original Message- From: Jean-Marc Spaggiari [mailto:jean-m...@spaggiari.org] Sent: Wednesday, May 22, 2013 7:57 AM To: user@hbase.apache.org Subject: Re: Inconsistent Table HBCK Thanks for the feedback Jay. I helped someone who faced the

Re: Poor HBase map-reduce scan performance

2013-05-22 Thread Ted Yu
Sandy: Looking at patch v6 of HBASE-8420, I think it is different from your approach below for the case of cache.size() == 0. Maybe log a JIRA for further discussion ? On Wed, May 22, 2013 at 3:33 PM, Sandy Pratt prat...@adobe.com wrote: It seems to be in the ballpark of what I was getting at,

Re: Simple but Reliable configuration for pseudo distributed mode on ubuntu

2013-05-22 Thread Stack
I can work on the doc. part. If you have a moment, would suggest filing an issue w/ snippets of the logs where hbase is lost. Thanks Stephen, St.Ack On Wed, May 22, 2013 at 2:45 PM, Stephen Boesch java...@gmail.com wrote: Hi Stack, This section of the docs is clear. I would suggest it

Re: RS crash upon replication

2013-05-22 Thread Varun Sharma
It seems I can reproduce this - I did a few rolling restarts and got screwed with NoNode exceptions - I am running 0.94.7 which has the fix but my nodes don't contain hyphens - nodes are no longer coming back up... Thanks Varun On Wed, May 22, 2013 at 3:02 PM, Himanshu Vashishtha

Re: RS crash upon replication

2013-05-22 Thread Himanshu Vashishtha
That sounds like a bug for sure. Could you create a jira with logs/znode dump/steps to reproduce it? Thanks, himanshu On Wed, May 22, 2013 at 5:01 PM, Varun Sharma va...@pinterest.com wrote: It seems I can reproduce this - I did a few rolling restarts and got screwed with NoNode exceptions -

Re: Risk about RS logs clean ?

2013-05-22 Thread Bing Jiang
Hi,Sergey. The version of hbase in our environment is 0.94.3, and the FSHLog.java comes from 0.95 or version above. And it adds such codes in FSHLog::cleanOldLogs, long oldestOutstandingSeqNum = Long.MAX_VALUE; synchronized (oldestSeqNumsLock) { Long oldestFlushing =