Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-5324

Download query result as xlsx file works only first time

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 3.10.0
    • Fix Version/s: None
    • Component/s: app.editor, core.ui
    • Labels:
    • Environment:

      CDH 5.8.3

      Description

      Download query results only works first time.. then it always starts failing with (1) exception stack. I have to refresh Hue/ SQL editor (F5 in browser), then xlsx download works again, but only for first time after UI hard reload though F5..

      SQL editor for Impala, but I think the same problems exists for Hive SQL Editor too.

      (1)

      Traceback (most recent call last):
        File "/opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1215, in communicate
          req.respond()
        File "/opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 576, in respond
          self._respond()
        File "/opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 590, in _respond
          for chunk in response:
        File "/opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/utils/six.py", line 535, in next
          return type(self).__next__(self)
        File "/opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/http/response.py", line 292, in __next__
          return self.make_bytes(next(self._iterator))
        File "/opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/lib/hue/desktop/core/src/desktop/lib/export_csvxls.py", line 96, in create_generator
          for _headers, _data in content_generator:
        File "/opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/lib/hue/apps/beeswax/src/beeswax/data_export.py", line 72, in HS2DataAdapter
          results = db.fetch(handle, start_over=start_over, rows=FETCH_SIZE)
        File "/opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/lib/hue/apps/beeswax/src/beeswax/server/dbms.py", line 282, in fetch
          return self.client.fetch(query_handle, start_over, rows)
        File "/opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 1073, in fetch
          data_table = self._client.fetch_data(operationHandle, orientation=orientation, max_rows=max_rows)
        File "/opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 799, in fetch_data
          results, schema = self.fetch_result(operation_handle, orientation, max_rows)
        File "/opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 832, in fetch_result
          schema = self.call(self._client.GetResultSetMetadata, meta_req)
        File "/opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p0.2/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 642, in call
          raise QueryServerException(Exception('Bad status for request %s:\n%s' % (req, res)), message=message)
      QueryServerException: Bad status for request TGetResultSetMetadataReq(operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret='\x112cjq3Oh\xb1\xc9\xca\xd9\x94G\x08\xe7', guid='\x112cjq3Oh\xb1\xc9\xca\xd9\x94G\x08\xe7'))):
      TGetResultSetMetadataResp(status=TStatus(errorCode=None, errorMessage='Invalid query handle', sqlState='HY000', infoMessages=None, statusCode=3), schema=None)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                tagar Ruslan Dautkhanov
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: