Support Questions
Find answers, ask questions, and share your expertise

Unable to connect to Hive while the services are up and running on ambari

Unable to connect to Hive while the services are up and running on ambari

New Contributor

Hi,

 

All the HIVE services are up and running on the ambari UI but we are unable to query hive. can see 2 critical alerts and logs are as below. Apache Ranger is up and running and all policies are available too.

While using any user to query "show databases" getting this error 

SQL Error [40000] [42000]: Error while compiling statement:

FAILED: HiveAccessControlException Permission denied:

user [xxxxxx] does not have [USE] privilege on [Unknown resource!!]

Connection failed on host ip-xx-xxx-xx-xx.eu-west-1.compute.internal:10001 (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://ip-xx-xxx-xx-xx.eu-west-1.compute.internal:10001/;transportMode=http;httpPath=cliservice' -n 'xxxxxxx' -p '[PROTECTED]' -e ';' 2>&1 | awk '{print}' | grep -i -e 'Connected to:' -e 'Transaction isolation:'' returned 1. 
)

Screen Shot 2021-04-16 at 5.31.04 PM.png