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

Not able to see databases in HUE for Hive/Beeswax

Rising Star

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))

1 ACCEPTED SOLUTION

Rising Star

Hi @cjervis i resolved it by adding the below parameter

 

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

View solution in original post

5 REPLIES 5

@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?

 

 

Rising Star

@stevenmatison 

 

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

 

Thanks

Bharad

Community Manager

@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. 

 

Screen Shot 2019-08-06 at 1.54.47 PM.png


Cy Jervis, Manager, Community Program
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Rising Star

Hi @cjervis i resolved it by adding the below parameter

 

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

New Contributor

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.