question Re: unable to read hiveserver2 configs from zookeeper (state=,code=0) in Support Questions

unable to read hiveserver2 configs from zookeeper (state=,code=0)

deepak_s2 — Fri, 27 Jul 2018 00:22:40 GMT

Hi all, I have installed ambari and every service was running good, but im getting 2 alerts on hive. i tried to resolve but i'm unable to do that. can anyone help me out?

- i'm able to login to mysql and beeline also.

==================

Hive error

==========================================================================================

root@ARIES-HDP-WNODE1:/etc# beeline -u "jdbc:hive2://aries-hdp-wnode1.ariessystem.us:2181,aries-hdp-mnode.ariessystem.us:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" Connecting to jdbc:hive2://aries-hdp-wnode1.ariessystem.us:2181,aries-hdp-mnode.ariessystem.us:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 Error: org.apache.hive.jdbc.ZooKeeperHiveClientException: Unable to read HiveServer2 configs from ZooKeeper (state=,code=0) Beeline version 1.2.1000.2.6.5.0-292 by Apache Hive 0: jdbc:hive2://aries-hdp-wnode1.ariessystem. (closed)>

==============================================================================================

Here i attach the hive server log and alert pictures from ambarihive-metastore-log.txt

hive-alert1.png hive-alert-2.png alert-3.png

@Jay Kumar SenSharma

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

vmurakami — Tue, 31 Jul 2018 12:04:45 GMT

Hello @Deepak SANAGAPALLI!
Could you check your mysql connector?

#[root@node1 ~]# ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar #I made my setup with this jdbc-driver
#Finding my jar
[root@node1 ~]# find / -name "mysql-connector-java.jar" -type f
/tmp/mysql-connector-java.jar
/usr/share/java/mysql-connector-java.jar
/var/lib/ambari-server/resources/mysql-connector-java.jar
[root@node1 ~]# ls -ltrah /var/lib/ambari-server/resources/mysql-connector-java.jar
-rw-r--r-- 1 root root 864K Jul 26 23:48 /var/lib/ambari-server/resources/mysql-connector-java.jar
[root@node1 ~]# ls -ltrah /usr/share/java/mysql-connector-java.jar
-rw-r--r-- 1 root root 864K Jul 26 22:52 /usr/share/java/mysql-connector-java.jar

Hope this helps!

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

deepak_s2 — Wed, 01 Aug 2018 00:27:27 GMT

mysql-jdbc-connector-error.pngHI @Vinicius Higa Murakami, Thank you for your reply. I don't see any MySQL-connector-java.jar when i run this command "

find / -name "mysql-connector-java.jar" -type f ". I'm getting this error when i ran this command "

#[root@node1 ~]# ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar #I made my setup with this jdbc-driver". Please look at the attached screen shot and cloud you please help me out in how to install those MySQL-jdbc conector. Thanks in advance and i appreciate your help.

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

vmurakami — Wed, 01 Aug 2018 00:34:49 GMT

Hello @Deepak SANAGAPALLI.
Take a look at this documentation
https://docs.hortonworks.com/HDPDocuments/Ambari-2.7.0.0/bk_ambari-installation/content/install-mysql.html

Hope this helps

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

deepak_s2 — Wed, 01 Aug 2018 00:52:56 GMT

Hi @Vinicius Higa Murakami, just to confirm I need to just download the mysql-connector-java.jar, am i correct??

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

vmurakami — Wed, 01 Aug 2018 00:55:21 GMT

Hi @Deepak SANAGAPALLI!
If you chose MYSQL as your flavour to HiveMetaStore yeah 🙂
Just one thing, make sure to do this at the ambari server host

Hope this helps!

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

Shelton — Wed, 01 Aug 2018 01:03:45 GMT

@Deepak SANAGAPALLI

If the MySQL connector doesn't exist just run the below command the default install dir is /usr/share/java/

# yum install -y mysql-connector-java

Then rerun the ambari setup

# ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar

That should resolve the issue

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

deepak_s2 — Wed, 01 Aug 2018 01:09:33 GMT

Hi @Geoffrey Shelton Okot @Vinicius Higa Murakami , i'm using Ubuntu so my command will be

1. apt-get install -y mysql-connector-java

2. ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar

Is this right? Thank you for you help all of you.

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

vmurakami — Wed, 01 Aug 2018 01:10:36 GMT

Yeah! It is 🙂
Just don't forget to restart your ambari-server okay?

ambari-server restart

Hope this helps!

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

deepak_s2 — Wed, 01 Aug 2018 01:19:20 GMT

Hi @Vinicius Higa Murakami @Geoffrey Shelton Okot when i ran this command "apt-get install -y mysql-connector-java " mysqlerror.pngI'm getting this error.

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

vmurakami — Wed, 01 Aug 2018 02:00:36 GMT

In this case, you'll have to use the following options:

apt-get install -y mysql-connector-java_8.0.12-1ubuntu18.04_all.deb
#or if you're using a minor version of Ubuntu
apt-get install -y mysql-connector-java_8.0.12-1ubuntu16.04_all.deb

If the issue persists, you can try to download it manually
https://dev.mysql.com/downloads/connector/j/

Hope this helps!

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

deepak_s2 — Wed, 01 Aug 2018 03:11:44 GMT

Hi @Vinicius Higa Murakami , i'm currently using Ubuntu 14.04 i don't see that option in MySQL.com when I'm trying to download manually and when i ran the command by changing the version to

apt-get install -y mysql-connector-java_8.0.12-1ubuntu14.04_all.deb, I'm getting the following error.mysql-error2.png can you please help me out.

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

vmurakami — Wed, 01 Aug 2018 03:57:20 GMT

Hi @Deepak SANAGAPALLI.
Try to install using this command:

apt-get install libmysql-java

Hope this helps!

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

deepak_s2 — Wed, 01 Aug 2018 04:04:43 GMT

Hi @Vinicius Higa Murakami , i ran that command and it got installed. can you please tell me what steps to be performed next.sqllib-java.png

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

vmurakami — Wed, 01 Aug 2018 04:07:35 GMT

@Deepak SANAGAPALLI, now you should see the mysql-connector-java.jar under the libmysql-java.
You can try to find it with the following command:

find / -name "mysql-connector*" -type f -exec ls -ltrah {} \;

If you are able to see it, then just follow the instruction inside that documentation link.

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

deepak_s2 — Wed, 01 Aug 2018 04:21:04 GMT

Thanks a lot @Vinicius Higa Murakami @Geoffrey Shelton Okot issue resolved. i appreciate for helping me.

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

vmurakami — Wed, 01 Aug 2018 04:23:01 GMT

Hi @Deepak SANAGAPALLI!
Glad to hear that! Keep it up with your HiveServer and let us know if you find any other issues 🙂
Thanks

Re: unable to read hiveserver2 configs from zookeeper (state=,code=0)

AshishVarma — Tue, 04 Aug 2020 14:30:02 GMT

Could you please let us know which documentation you are talking about?