Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CDH5 5.6.0
    • Fix Version/s: None
    • Component/s: Hue
    • Labels:
    • Environment:
      CentOS 6.7

      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=

      {'QUERY_TIMEOUT_S': '600'}

      , 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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              ashrestha Ashim Shrestha
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: