Error: Failed with exception java.io.IOException:Time limit exceeded for local fetch task with SimpleFetchOptimization

Venkata Krishnan S

January 23, 2017 18:53

Symptom:

Executing a query with Hive in Qubole returns the following error:

Failed with exception java.io.IOException:Time limit exceeded for local fetch task with SimpleFetchOptimization

Action:

Include the following line at the top of the query:

set hive.fetch.task.conversion=none;

Have more questions? Submit a request

Andrew Candela January 23, 2017 18:53

Looks like 'none' is no longer a valid value.

Query returned non-zero code: 1, cause: 'SET hive.fetch.task.conversion=none' FAILED in validation : Invalid value.. expects one of [minimal, more]. Seems like 'minimal' is now the way to go.

...At least as of hive 0.13

Permalink