Not able to see databases in HUE for Hive/Beeswax

bhara — Tue, 21 Apr 2026 11:31:05 GMT

Team ,

I am not able to see any databases when i configure HUE with hive . below is the only error i see in the logs and i cannot make out what exactly is the error .

[15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift call: <class 'TCLIService.TCLIService.Client'>.FetchResults(args=(TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret=7748957ba2246f2a:ede5df3998017cb5, guid=19445a4be1c2c692:e2e7ddb12ee4788f)), orientation=0, maxRows=5000),), kwargs={}) returned in 5ms: TFetchResultsResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0), results=TRowSet(columnCount=None, binaryColumns=None, rows=[], columns=[TColumn(i32Val=None, byteVal=None, i16Val=None, i64Val=None, stringVal=TStringColumn(nulls='\x00', values=[]), boolVal=None, doubleVal=None, binaryVal=None), TColumn(i32Val=None, byteVal=None, i16Val=None, i64Val=None, stringVal=TStringColumn(nulls='\x00', values=[]), boolVal=None, doubleVal=None, binaryVal=None)], startRowOffset=0), hasMoreRows=False)
[15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift client <desktop.lib.thrift_util.ConnectionPooler object at 0x7fe2b85b54d0> got connection 49 after 0.00 seconds
[15/Apr/2020 11:31:35 -0700] hive_server2_lib DEBUG 1 sessions found
[15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift client <desktop.lib.thrift_util.ConnectionPooler object at 0x7fe2b85b54d0> got connection 49 after 0.00 seconds
[15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift call: <class 'TCLIService.TCLIService.Client'>.GetResultSetMetadata(args=(TGetResultSetMetadataReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret=7748957ba2246f2a:ede5df3998017cb5, guid=19445a4be1c2c692:e2e7ddb12ee4788f))),), kwargs={})
[15/Apr/2020 11:31:35 -0700] connectionpool DEBUG http://catl0dlbd00027.corp.cox.com:10001 "POST /cliservice/ HTTP/1.1" 200 None
[15/Apr/2020 11:31:35 -0700] kerberos_ DEBUG handle_mutual_auth(): Handling: 200
[15/Apr/2020 11:31:35 -0700] kerberos_ DEBUG handle_response(): returning <Response [200]>
[15/Apr/2020 11:31:35 -0700] resource DEBUG POST <class 'requests_kerberos.kerberos_.HTTPKerberosAuth'> http://catl0dlbd00027.corp.cox.com:10001/cliservice/ �GetResultSetMetadata

��KZD�x�.��
*o$�{�Hw�|�9�� returned in 6ms 200 201 �GetResultSetMetadata

TABLE_SCHEM

Schema name.
TABLE_CATALOG

Catalog name.
[15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift call: <class 'TCLIService.TCLIService.Client'>.GetResultSetMetadata(args=(TGetResultSetMetadataReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret=7748957ba2246f2a:ede5df3998017cb5, guid=19445a4be1c2c692:e2e7ddb12ee4788f))),), kwargs={}) returned in 8ms: TGetResultSetMetadataResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0), schema=TTableSchema(columns=[TColumnDesc(comment='Schema name.', columnName='TABLE_SCHEM', typeDesc=TTypeDesc(types=[TTypeEntry(mapEntry=None, unionEntry=None, arrayEntry=None, userDefinedTypeEntry=None, structEntry=None, primitiveEntry=TPrimitiveTypeEntry(typeQualifiers=None, type=7))]), position=1), TColumnDesc(comment='Catalog name.', columnName='TABLE_CATALOG', typeDesc=TTypeDesc(types=[TTypeEntry(mapEntry=None, unionEntry=None, arrayEntry=None, userDefinedTypeEntry=None, structEntry=None, primitiveEntry=TPrimitiveTypeEntry(typeQualifiers=None, type=7))]), position=2)]))
[15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift client <desktop.lib.thrift_util.ConnectionPooler object at 0x7fe2b85b54d0> got connection 49 after 0.00 seconds
[15/Apr/2020 11:31:35 -0700] hive_server2_lib DEBUG 1 sessions found
[15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift client <desktop.lib.thrift_util.ConnectionPooler object at 0x7fe2b85b54d0> got connection 49 after 0.00 seconds
[15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift call: <class 'TCLIService.TCLIService.Client'>.CloseOperation(args=(TCloseOperationReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret=7748957ba2246f2a:ede5df3998017cb5, guid=19445a4be1c2c692:e2e7ddb12ee4788f))),), kwargs={})
[15/Apr/2020 11:31:35 -0700] connectionpool DEBUG http://catl0dlbd00027.corp.cox.com:10001 "POST /cliservice/ HTTP/1.1" 200 None
[15/Apr/2020 11:31:35 -0700] kerberos_ DEBUG handle_mutual_auth(): Handling: 200
[15/Apr/2020 11:31:35 -0700] kerberos_ DEBUG handle_response(): returning <Response [200]>
[15/Apr/2020 11:31:35 -0700] resource DEBUG POST <class 'requests_kerberos.kerberos_.HTTPKerberosAuth'> http://catl0dlbd00027.corp.cox.com:10001/cliservice/ �CloseOperation

��KZD�x�.��
*o$�{�Hw�|�9�� returned in 5ms 200 42 �CloseOperation

[15/Apr/2020 11:31:35 -0700] thrift_util DEBUG Thrift call: <class 'TCLIService.TCLIService.Client'>.CloseOperation(args=(TCloseOperationReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret=7748957ba2246f2a:ede5df3998017cb5, guid=19445a4be1c2c692:e2e7ddb12ee4788f))),), kwargs={}) returned in 6ms: TCloseOperationResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0))

Re: Not able to see databases in HUE for Hive/Beeswax

stevenmatison — Thu, 16 Apr 2020 12:36:58 GMT

@bhara I don't see an actual error message in there. I just notice the result output has rows = none. Does the user you are logging into HUE with have permissions to see the database and tables?

Can you share your hue.ini hive configuration lines?

Re: Not able to see databases in HUE for Hive/Beeswax

bhara — Thu, 16 Apr 2020 14:10:21 GMT

@stevenmatison

Thanks for looking into it .I was able to fix the issue .

Thanks

Bharad

Re: Not able to see databases in HUE for Hive/Beeswax

cjervis — Thu, 16 Apr 2020 18:10:35 GMT

@bhara

I'm happy to see you resolved your issue. Please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.

Re: Not able to see databases in HUE for Hive/Beeswax

Thoma1s — Thu, 16 Apr 2020 20:26:15 GMT

They show up in hive or when you use impala-shell. It's only in the drop down in Hue that they are not seen.

Re: Not able to see databases in HUE for Hive/Beeswax

bhara — Tue, 21 Apr 2020 13:25:03 GMT

Hi @cjervis i resolved it by adding the below parameter

hive.server2.parallel.ops.in.session=true under Hive > Config > Advanced > "Custom hive-site" .

question Re: Not able to see databases in HUE for Hive/Beeswax in Support Questions

Not able to see databases in HUE for Hive/Beeswax

Re: Not able to see databases in HUE for Hive/Beeswax

Re: Not able to see databases in HUE for Hive/Beeswax

Re: Not able to see databases in HUE for Hive/Beeswax

Re: Not able to see databases in HUE for Hive/Beeswax

Re: Not able to see databases in HUE for Hive/Beeswax