Hi all,
i’m try to connect Hue 4.8 with impala 3.0.0-cdh6.0.0, from editor i can see all databases but if try to refresh tables or execute some query i received this error:
[23/Jan/2021 12:46:46 -0800] thrift_util WARNING Unable to unpack the secret and guid in Thrift Handle: unpack requires a buffer of 16 bytes
[23/Jan/2021 12:46:46 -0800] api ERROR Autocomplete data fetching error
Traceback (most recent call last):
File “/usr/share/hue/apps/beeswax/src/beeswax/api.py”, line 111, in _autocomplete
response[‘functions’] = _get_functions(db, database)
File “/usr/share/hue/apps/beeswax/src/beeswax/api.py”, line 183, in _get_functions
functions = db.get_functions(prefix=database)
File “/usr/share/hue/apps/beeswax/src/beeswax/server/dbms.py”, line 1167, in get_functions
handle = self.execute_and_wait(query, timeout_sec=5.0)
File “/usr/share/hue/apps/beeswax/src/beeswax/server/dbms.py”, line 973, in execute_and_wait
handle = self.client.query(query)
File “/usr/share/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py”, line 1420, in query
return self._client.execute_async_query(query, statement, session=session)
File “/usr/share/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py”, line 988, in execute_async_query
return self.execute_async_statement(statement=query_statement, conf_overlay=configuration, session=session)
File “/usr/share/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py”, line 1021, in execute_async_statement
(res, session) = self.call_return_result_and_session(thrift_function, thrift_request, session=session)
File “/usr/share/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py”, line 753, in call_return_result_and_session
return self._call_return_result_and_session(fn, req, status=status, session=session)
File “/usr/share/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py”, line 790, in _call_return_result_and_session
raise QueryServerException(Exception(message), message=message)
beeswax.server.dbms.QueryServerException: Malformed THandleIdentifier (guid size: 17, expected 16, secret size: 17, expected 16)
2021-01-23T20:46:46.959706000Z
[23/Jan/2021 12:46:46 -0800] access INFO 172.18.0.1 marco - “POST /notebook/api/autocomplete/ HTTP/1.1” returned in 73ms 200 129
[23/Jan/2021 12:46:46 -0800] access INFO 172.18.0.1 marco - “POST /notebook/api/autocomplete/ HTTP/1.1” returned in 73ms 200 129
172.18.0.1 - - [23/Jan/2021:20:46:46 +0000] “POST /notebook/api/autocomplete/ HTTP/1.1” 200 129 “http://localhost:8888/hue/editor/?type=impala” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36”
this is my hue setting:
[impala]
Hot of the Impala Server (one of the Impalad)
server_host=impala
Port of the Impala Server
server_port=21050
coordinator_url=http://impala:25000
impersonation_enabled=false
#use_thrift_http=true
Can someone help me to resolve this issue?
Thanks