Reply
New Contributor
Posts: 2
Registered: ‎01-07-2016

Data sample error

I was try to open Data sample in hue->impala, but show error:

 

Bad status for request TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret='D/\xcd\xbf\xdb\xbbD\x1e\xad"\xd5W\xe3^N\x81', guid='D/\xcd\xbf\xdb\xbbD\x1e\xad"\xd5W\xe3^N\x81')), orientation=4, maxRows=1000):
TFetchResultsResp(status=TStatus(errorCode=None, errorMessage='Restarting of fetch requires enabling of query result caching.\n', sqlState='HY000', infoMessages=None, statusCode=3), results=None, hasMoreRows=None)

I can't resolve this question, please help me

Cloudera Employee
Posts: 723
Registered: ‎07-30-2013

Re: Data sample error

Which CDH version? Are you using CM?
New Contributor
Posts: 2
Registered: ‎01-07-2016

Re: Data sample error

CDH version is 5.5.1 , yes I'm using CM
New Contributor
Posts: 2
Registered: ‎04-07-2016

Re: Data sample error

Did you find a solution for this?

Cloudera Employee
Posts: 723
Registered: ‎07-30-2013

Re: Data sample error

It might have been an issue in this CDH version, but should be fixed in
latest 5.5.x or 5.

Impala was not configured to allow Hue to refetch data:
"Restarting of fetch requires enabling of query result caching"

e.g. it works on http://demo.gethue.com/impala which is 5.5
New Contributor
Posts: 2
Registered: ‎04-07-2016

Re: Data sample error

Hi,

 

We already have a 5.5 Cloudera Version and it isn't working right now. We plan to migrate to 5.5.2 asap, I don't know if there the problem is solved.

 

I will give some feedback about this

 

 

Thank you.

Cloudera Employee
Posts: 723
Registered: ‎07-30-2013

Re: Data sample error

In the Impala configuration, is this set?

Result Cache Maximum Size
max_result_cache_size

100000