Member since
01-29-2014
10
Posts
1
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
4812 | 02-03-2014 12:09 PM | |
3595 | 01-29-2014 03:19 PM |
02-03-2014
12:09 PM
1 Kudo
We managed to get this issue resloved. The problem acutally had nothing to do with Hive but Zookeeper. By default there is a limit of 60 active connections from a single IP address. We were running over this limit becuase we have such a small cluster(4 servers). We upped the limit on connections to 200 and everything started working properly.
... View more
02-03-2014
08:45 AM
Hi Darren, I have tried both HiveServer and HiveServer2,with basically the same results. after about eight hours things just stop working. Connection tests still pass, but whenever we attempt to pull data, the process just hangs(we have tried from mutiple applications, Eclipse,SquirrelSQL, and JasperServer). We are using the latest version of CDH. I wll have a look at the Blog post. Thanks! Andrew
... View more
02-01-2014
10:02 PM
Hi, I am running a four node instance of CHD on AWS(m1.mediums). We are running into some very odd behaviour that I am hoping someone can help me troubleshoot. We have imported some data into hive using a few different methods(Sqoop, and direct import), And we then connecting Hive to an instance of JaserSoft, to run build some basic reports. Everything works fine for a period of a few hours(4-6) then the connections to Hive start to fail, for no reason that I can see. I have tried looking through what logs I see, but nothing is jumping out at me. I am seeing a number of logs that look like this: /var/log/hadoop-0.20-mapreduce/history/done/ip-10-139-5-19.ec2.internal_1391232018142_/2014/02/02/000000# less job_201402010520_0032_1391311952515_root_select+count%28\*%29+as+trp_erro...error_code%3D203%28Stage but the test in them doesn't indicate any problems. I am very new to the Hadoop world, so forgive me if this is a simple issue, but can anyone give me any hints at how I might troubleshoot this issue? I have rebuilt the entire cluster from scratch once already, so I know this must be some sort of configuration issue. We are running the laster CDH instance, I started the thrift server in the ubunut home directory using: hive --service hiveserver -p 10000 & Thanks Andrew
... View more
Labels:
01-29-2014
03:19 PM
In case anyone else runs into this issue. The problem was that the Thrift server wasn't running. Once we started that on our target system(hive --service hiveserver ) We were able to connect via JDBC.
... View more
01-29-2014
10:02 AM
Hi, I have set up a four node CDH cluster using the following instructions(http://blog.cloudera.com/blog/2013/03/how-to-create-a-cdh-cluster-on-amazon-ec2-via-cloudera-manager/) Everything seems to be up and running, but I having difficulty connecting to the cluster's hive instance using JDBC. I have verified the following Hive is up and running Port 10000 has been added to my security group I am trying to connect to hive from another AWS instance using the public interface(I am running Jaspersoft on this instance). Here is my connection string(ip specifics Xed out): jdbc:hive://ec2-xx-xx-x-xx.compute-1.amazonaws.com:10000/default When I try to use this I am getting a connection refused message on the client side, and I am not seeing anything help in any of the server side messages. Does anyone have any ideas? Thanks
... View more
Labels: