Accessing HUE Metastore Manager in BDA 4.4.0/CDH 5.5.1 Gives Errors: "Failed to retrieve tables for database..." and "Unable to access databases. Query Server or Metastore may be down"
(Doc ID 2279625.1)
Last updated on NOVEMBER 27, 2024
Applies to:
Big Data Appliance Integrated Software - Version 4.4.0 and laterInformation in this document applies to any platform.
Symptoms
An error is raised on BDA V4.4.0/CDH 5.5.1 when navigating to the HUE Metastore Manager (HMS) via the web browser.
Failed to retrieve tables for database: mydb
Bad status for request TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret=*, guid=")\*")), orientation=0, maxRows=5000): TFetchResultsResp(status=TStatus(errorCode=0, errorMessage='Expected state FINISHED, but found ERROR', sqlState=None, infoMessages=['*org.apache.hive.service.cli.HiveSQLException:Expected state FINISHED, but found ERROR:26:25', 'org.apache.hive.service.cli.operation.Operation:assertState:Operation.java:164', 'org.apache.hive.service.cli.operation.SQLOperation:getNextRowSet:SQLOperation.java:311', 'org.apache.hive.service.cli.operation.OperationManager:getOperationNextRowSet:OperationManager.java:262', 'org.apache.hive.service.cli.session.HiveSessionImpl:fetchResults:HiveSessionImpl.java:732', 'sun.reflect.GeneratedMethodAccessor15:invoke::-1', 'sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43', 'java.lang.reflect.Method:invoke:Method.java:497', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78', 'org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36', 'org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63', 'java.security.AccessController:doPrivileged:AccessController.java:-2', 'javax.security.auth.Subject:doAs:Subject.java:422', 'org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1671', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59', 'com.sun.proxy.$Proxy19:fetchResults::-1', 'org.apache.hive.service.cli.CLIService:fetchResults:CLIService.java:438', 'org.apache.hive.service.cli.thrift.ThriftCLIService:FetchResults:ThriftCLIService.java:695', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults
This happens for only one user and this same user also encounters errors when trying to to run a query in Hue (i.e. using a describe command):
"Expected state FINISHED, but found ERROR
Your query has the following error(s):
Unable to access databases. Query Server or Metastore may be down."
This problem happens with both Google Chrome and Internet Explorer web browsers and persists even after clearing the browser cache. The user that encounters this error is a member of a group called '<group_name>.' Other users in this same group, do not experience the error.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |