Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error when Exporting Results

Solved Go to solution
Highlighted

Error when Exporting Results

Contributor

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)

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Error when Exporting Results

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

Re: Error when Exporting Results

How large is the result?

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

Re: Error when Exporting Results

Contributor

Its over 70MB

Re: Error when Exporting Results

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

Re: Error when Exporting Results

Contributor

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

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

Re: Error when Exporting Results

Contributor
Don't have an account?
Coming from Hortonworks? Activate your account here