title: Impyla return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask when querying HiveServer2
body: <p>I am using <a href="https://github.com/cloudera/impyla" rel="nofollow noreferrer">Impyla</a> for querying some results from HIVE, however, I met this problem:</p>
  
  <p>From Impyla:</p>
  
  <pre><code>impala.error.OperationalError: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
  </code></pre>
  
  <p>and from HiveServer2:</p>
  
  <pre><code>WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
  Query ID = hduser_20180827031927_fdb148b0-725b-434c-a0f8-98b6843d4348
  Total jobs = 1
  Launching Job 1 out of 1
  Number of reduce tasks not specified. Defaulting to jobconf value of: 1
  In order to change the average load for a reducer (in bytes):
    set hive.exec.reducers.bytes.per.reducer=&lt;number&gt;
  In order to limit the maximum number of reducers:
    set hive.exec.reducers.max=&lt;number&gt;
  In order to set a constant number of reducers:
    set mapreduce.job.reduces=&lt;number&gt;
  FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
  </code></pre>
  
  <p>and my source code is:</p>
  
  <pre><code>from impala.dbapi import connect
  import sys
  
  
  dbName = sys.argv[1:][0]
  query = sys.argv[1:][1]
  
  conn = connect(host='192.168.0.10', port=10000, database=dbName , auth_mechanism='NOSASL' , use_ssl=True)
  cursor = conn.cursor()
  cursor.execute(query, configuration={'hive.exec.reducers.bytes.per.reducer': '100000', 'hive.auto.convert.join.noconditionaltask':'false','mapreduce.job.reduces':'1','hive.auto.convert.join':'false'})
  returnData = []
  for row in cursor:
      returnData.append(row[0])
  pprint(returnData)
  </code></pre>
  
  <p>as you see I have added many configurations, but it does not work</p>