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))
Created 04-21-2020 06:25 AM
Hi @cjervis i resolved it by adding the below parameter
hive.server2.parallel.ops.in.session=true under Hive > Config > Advanced > "Custom hive-site" .
Created 04-16-2020 05:36 AM
@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?
Created 04-16-2020 07:10 AM
Created 04-16-2020 11:10 AM
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.
Created 04-21-2020 06:25 AM
Hi @cjervis i resolved it by adding the below parameter
hive.server2.parallel.ops.in.session=true under Hive > Config > Advanced > "Custom hive-site" .
Created 04-16-2020 01:26 PM
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.