Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hiveserver2 not starting

Solved Go to solution
Highlighted

Hiveserver2 not starting

Explorer

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. 
)
      
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Hiveserver2 not starting

Explorer
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!

View solution in original post

3 REPLIES 3

Re: Hiveserver2 not starting

Guru
@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
Highlighted

Re: Hiveserver2 not starting

Explorer
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!

View solution in original post

Highlighted

Re: Hiveserver2 not starting

Guru
Glad it works now, thanks for sharing.

Cheers
Don't have an account?
Coming from Hortonworks? Activate your account here