Error when Exporting Results

krishnat — Tue, 21 Apr 2026 13:48:48 GMT

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)

Re: Error when Exporting Results

Romainr — Fri, 14 Oct 2016 21:07:19 GMT

How large is the result?

More than few MB can error currently:
https://issues.cloudera.org/browse/HUE-2142

Re: Error when Exporting Results

krishnat — Fri, 14 Oct 2016 21:09:00 GMT

Its over 70MB

Re: Error when Exporting Results

Romainr — Fri, 21 Oct 2016 06:17:26 GMT

Yes, more than 25MB can take a while currently and eventually fail

Re: Error when Exporting Results

krishnat — Fri, 21 Oct 2016 14:33:15 GMT

It would be great if JDBC connection to a Kerberosed Cluster worked. I opened a seperate ticket on that, lets see where that goes.

Re: Error when Exporting Results

Romainr — Mon, 24 Oct 2016 08:44:42 GMT

We can follow-up on the ticket, we would love some help on the JDBC
connector!

question Re: Error when Exporting Results in Archives of Support Questions (Read Only)

Error when Exporting Results

Re: Error when Exporting Results

Re: Error when Exporting Results

Re: Error when Exporting Results

Re: Error when Exporting Results

Re: Error when Exporting Results

Re: Error when Exporting Results