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.

Not able to see databases in HUE for Hive/Beeswax

Solved Go to solution

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

Accepted Solutions
Highlighted

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

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
Highlighted

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

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

 

 

 


 


If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.  


 


Thanks,



Steven

Highlighted

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

Rising Star

@stevenmatison 

 

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

 

Thanks

Bharad

Highlighted

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

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, Community Manager

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.

Learn more about the Cloudera Community:
Community Guidelines
How to use the forum
Highlighted

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

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

Highlighted

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

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.

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