Details
Description
Hi there,
I am trying to run Impala query against CDH 5.6.0 using Hue (hue-3.9.0+cdh5.6.0+365-1.cdh5.6.0.p0.105.el6.x86_64). But any query including 'show tables' returns following error on the UI
AnalysisException: Syntax error in line 1: USE `` ^ Encountered: EMPTY IDENTIFIER Expected: IDENTIFIER CAUSED BY: Exception: Syntax error
and following error in /var/log/hue/error.log
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 688, in execute_query
return self.execute_query_statement(statement=query.query['query'], max_rows=max_rows, configuration=configuration)
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 692, in execute_query_statement
(results, schema), operation_handle = self.execute_statement(statement=statement, max_rows=max_rows, configuration=configuration, orientation=orientation)
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 720, in execute_statement
res = self.call(self._client.ExecuteStatement, req)
File "/usr/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 602, in call
raise QueryServerException(Exception('Bad status for request %s:\n%s' % (req, res)), message=message)
QueryServerException: Bad status for request TExecuteStatementReq(confOverlay=
, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(secret='\x03\xdd\xb8Y\xe8*K\x13\xa3r\x14\x9c$doK', guid="\x81N\x11u\x05WM2\xb5}A'K'\xb8\x11")), runAsync=False, statement='USE ``'):
TExecuteStatementResp(status=TStatus(errorCode=None, errorMessage='AnalysisException: Syntax error in line 1:\nUSE ``\n ^\nEncountered: EMPTY IDENTIFIER\nExpected: IDENTIFIER\n\nCAUSED BY: Exception: Syntax error\n', sqlState='HY000', infoMessages=None, statusCode=3), operationHandle=None)
However, after above failure, the query sits under 'Recent queries' and the query can be run successfully by clicking on the failed query, text box gets populated and click Execute.
Not sure if anybody has reported this issue yet. If duplicate, appreciate your guidance.
Thanks