KB440288: Check points for Hive generic error “(35) Error from server: error code: '0' error message”

Generic error Error: "(35) Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE" errors in Strategy 10.x, below is the list of check points to fix the error.  
 

• Ensure that the user have permissions to access the table.
  Change the user to hdfs as that user has the required permissions to read/write data from hdfs
   

Refer to Technical document below for the typical scenario:
“Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE” Error Message Appears When Running a Report in MicroStrategy Developer Against Hortonworks Hadoop Hive Data Warehouse
 

• Run this query from the hive shell and look at the hive logs for the correct error message.

• If below “Java.outof memory” error occurs, it is because tez is running out of memory.

 “Hive on Tez query Map output OutOfMemoryError: Java heap space at java.nio.HeapByteBuffer.(HeapByteBuffer.java:57)”
Set hive.tez.container.size to be the same as or a small multiple (1 or 2 times that) of YARN container size yarn.scheduler.minimum-allocation-mb but NEVER more than yarn.scheduler.maximum-allocation-mb.

• Set the following properties via hive shell as an example and the query is able to be run successfully. set hive.tez.container.size=4096

set hive.tez.java.opts=-Xmx3276m (0.8 times hive.tez.container.size)
set tez.runtime.io.sort.mb=1638 (0.4 times hive.tez.container.size)
set tez.runtime.unordered.output.buffer.size-mb=409 (0.1 times hive.tez.container.size)
 
 
 
Article Reference Number: KB440288
  KB440288