-
Notifications
You must be signed in to change notification settings - Fork 22
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
ZooKeeper connection refused #1
Comments
Hi @coke519, which JDBC driver are you using and which is the JDBC connection url? I'll try to reproduce your error. |
Hi @coke519 , I have updated some updates to the master. url: jdbc:hive2://localhost:10000/postgres without problems. |
Hi @mcapitanio, I was pairing with @coke519 yesterday on this. We are using the hive-jdbc 2.1.0 driver to connect. We are using the same url that you posted. We have successfully connected from DBVisualizer and RubyMine using this driver. However, when we actually try to run a query like Were you able to run queries and get results from DBeaver? |
Hi @mcapitanio, yes just like @MattReidArnold said, we can successfully connect, but it's when we try to run a query that we get a ZooKeeper connection. |
@coke519 @MattReidArnold sorry for the delay, I am a bit busy in these days, hoping to try in next days. Yesterday I tried but I had also problems to connect witb DbVisualizer, for other reasons so I gave up. But could you try to make this update to the /hive/conf/hive-site.xml adding this fragment:
and then rebuilding the Docker Image with:
or if this doesn't solve the problem trying adding this snippet:
and rebuilding the image again? |
I have been unable to try your suggestion because I'm now having trouble getting
I'm a docker noob so I don't know how to troubleshoot this problem very well. I have completely uninstalled docker and tried with a fresh install of everything with the same result. |
@MattReidArnold I have committed the first change I proposed you, but I had no time to test it. To rebuild an image you can pull the changes from master and recreating the docker using:
and then restarting it again:
Otherwise you can remove your existing image with:
and pulling the new one from the Docker Hub:
|
@mcapitanio It looks like #docker-compose.yml
...
hive:
build:
context: .
dockerfile: Dockerfile
image: mcapitanio/hive:2.1.1
... It is still getting stuck in the same loop i mentioned above.
|
MattReidArnold after having started the hive docker try stopping with:
This removes the container and the named volumes. Then try restarting again |
@mcapitanio I tried that and its still getting stuck in the same place. |
@MattReidArnold in the docher-compose.tml file there is rhe list of the exposed ports to the host. Coould you also che the logs that are located in Hive named volume, it should be under:
|
I'm not seeing a docker directory in /var/lib. Is that the problem? I ran
|
@MattReidArnold You should find that directory as root |
@mcapitanio Sorry, I'm a Docker noob. I'm running Docker for Mac and didn't realize I needed to look in the linux VM running under the hood. So this is what is showing up in the hive logs while the container is stuck in that look. Does this help?
|
@MattReidArnold It seems that the Hive Metastore in Postgres has not correctly created.
If not you probably are not running the last Docker image. So to be sure you should delete the image:
and rebuild from the master
The try to start again, eventually changing the project name:
|
@mcapitanio I will try it again on my work machine next week sometime and let you know if this fixes it there as well. Thanks for all of you help. Sorry to be such a pain. Have a Merry Christmas! |
Also, I noticed that the port for the web url on the zookeeper container is not exposed. To access http://localhost:8099/ in a browser I had to add this.
|
@MattReidArnold Great news then! Yes, I exposed that port on the ZooKeeper Image but not in this one, but it would be useful to expose that also in the Hive image. Merry Christmas to you too! |
@mcapitanio I verified that this also fixes it on my work machine. Thanks again. |
I pulled down this repo and ran
docker-compose -p docker up
to spin up all of the services. They all seem to be working individually. However, when I issue a sql command to the Hive server through a JDBC driver it just hangs. The Hive server logs show the following error connecting to ZooKeeper:Any suggestions?
Thanks
The text was updated successfully, but these errors were encountered: