Support Questions

Find answers, ask questions, and share your expertise

Who agreed with this topic

Error when Exporting Results

avatar
Rising Star

We are running a big query on Impala Tables. Once the results appear, when we try to export the results to CSV, we get the following error page. Any ideas, on what could be wrong here?

 

We are using CDH 5.7.2 - Impala, Spark on YARN, HUE along with HDFS.

 

 

Traceback (most recent call last):
  File "/opt/cloudera/parcels/CDH-5.7.2-1.cdh5.7.2.p0.18/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1215, in communicate
    req.respond()
  File "/opt/cloudera/parcels/CDH-5.7.2-1.cdh5.7.2.p0.18/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 576, in respond
    self._respond()
  File "/opt/cloudera/parcels/CDH-5.7.2-1.cdh5.7.2.p0.18/lib/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 590, in _respond
    for chunk in response:
  File "/opt/cloudera/parcels/CDH-5.7.2-1.cdh5.7.2.p0.18/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/utils/six.py", line 535, in next
    return type(self).__next__(self)
  File "/opt/cloudera/parcels/CDH-5.7.2-1.cdh5.7.2.p0.18/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/http/response.py", line 292, in __next__
    return self.make_bytes(next(self._iterator))
  File "/opt/cloudera/parcels/CDH-5.7.2-1.cdh5.7.2.p0.18/lib/hue/desktop/core/src/desktop/lib/export_csvxls.py", line 86, in create_generator
    for headers, data in content_generator:
  File "/opt/cloudera/parcels/CDH-5.7.2-1.cdh5.7.2.p0.18/lib/hue/apps/beeswax/src/beeswax/data_export.py", line 71, in HS2DataAdapter
    results = db.fetch(handle, start_over=start_over, rows=FETCH_SIZE)
  File "/opt/cloudera/parcels/CDH-5.7.2-1.cdh5.7.2.p0.18/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.7.2-1.cdh5.7.2.p0.18/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 1035, in fetch
    data_table = self._client.fetch_data(operationHandle, orientation=orientation, max_rows=max_rows)
  File "/opt/cloudera/parcels/CDH-5.7.2-1.cdh5.7.2.p0.18/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 786, in fetch_data
    results, schema = self.fetch_result(operation_handle, orientation, max_rows)
  File "/opt/cloudera/parcels/CDH-5.7.2-1.cdh5.7.2.p0.18/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 819, in fetch_result
    schema = self.call(self._client.GetResultSetMetadata, meta_req)
  File "/opt/cloudera/parcels/CDH-5.7.2-1.cdh5.7.2.p0.18/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='\n%?\xfe\x0f\x0eFR\x88T\x16iM\xe2(\x03', guid='\n%?\xfe\x0f\x0eFR\x88T\x16iM\xe2(\x03'))):
TGetResultSetMetadataResp(status=TStatus(errorCode=None, errorMessage='Invalid query handle', sqlState='HY000', infoMessages=None, statusCode=3), schema=None)

 

Who agreed with this topic