Hiveserver2 not starting

dewi — Fri, 31 Jan 2020 15:06:29 GMT

It seems hiveserver2 can't connect to hive metastore,

here is my log.

2020-01-31T15:47:46,804 INFO [main]: metastore.HiveMetaStoreClient (:()) - Closed a connection to metastore, current connections: 0 2020-01-31T15:47:46,804 INFO [main]: metastore.HiveMetaStoreClient (:()) - Trying to connect to metastore with URI thrift://novalinq-server:9083 2020-01-31T15:47:46,805 INFO [main]: metastore.HiveMetaStoreClient (:()) - Opened a connection to metastore, current connections: 1 2020-01-31T15:47:46,806 INFO [main]: metastore.HiveMetaStoreClient (:()) - Connected to metastore. 2020-01-31T15:47:46,814 WARN [main]: metastore.RetryingMetaStoreClient (:()) - MetaStoreClient lost connection. Attempting to reconnect (8 of 24) after 5s.

My jbdc is:

jdbc:hive2://novalinq-server:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2

And the last error hiveserver2 gives me is:

Connection failed on host novalinq-server:10000 (Traceback (most recent call last): File "/var/lib/ambari-agent/cache/stacks/HDP/3.0/services/HIVE/package/alerts/alert_hive_thrift_port.py", line 204, in execute ldap_password=ldap_password) File "/usr/lib/ambari-agent/lib/resource_management/libraries/functions/hive_check.py", line 84, in check_thrift_port_sasl timeout_kill_strategy=TerminateStrategy.KILL_PROCESS_TREE, File "/usr/lib/ambari-agent/lib/resource_management/core/base.py", line 166, in __init__ self.env.run() File "/usr/lib/ambari-agent/lib/resource_management/core/environment.py", line 160, in run self.run_action(resource, action) File "/usr/lib/ambari-agent/lib/resource_management/core/environment.py", line 124, in run_action provider_action() File "/usr/lib/ambari-agent/lib/resource_management/core/providers/system.py", line 263, in action_run returns=self.resource.returns) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 72, in inner result = function(command, **kwargs) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 102, in checked_call tries=tries, try_sleep=try_sleep, timeout_kill_strategy=timeout_kill_strategy, returns=returns) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 150, in _call_wrapper result = _call(command, **kwargs_copy) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 314, in _call raise ExecutionFailed(err_msg, code, out, err) ExecutionFailed: Execution of 'beeline -n hive -u 'jdbc:hive2://novalinq-server:10000/;transportMode=binary' -e ';' 2>&1 | awk '{print}' | grep -i -e 'Connected to:' -e 'Transaction isolation:'' returned 1. )

Re: Hiveserver2 not starting

EricL — Wed, 05 Feb 2020 07:34:40 GMT

@dewi

If HS2 was unable to connect to HMS, then you should check HMS log as well. What error is reported over there?

Cheers
Eric

Re: Hiveserver2 not starting

dewi — Wed, 05 Feb 2020 08:33:07 GMT

Hi,

I solved my problem.

Hadoop-proxyuser-hive wasn’t set to * and I had to add a an additional setup feature in the costum hive-site.xml.

Thanks for your reply!

Re: Hiveserver2 not starting

EricL — Wed, 05 Feb 2020 09:42:33 GMT

Glad it works now, thanks for sharing.

Cheers

question Hiveserver2 not starting in Support Questions

Hiveserver2 not starting

Re: Hiveserver2 not starting

Re: Hiveserver2 not starting

Re: Hiveserver2 not starting