Error "error code: '1' ... while processing statement" Interacting with Hadoop Hive Data

Published: 03 Oct 2013
Last Modified Date: 17 Jul 2017


After connecting to a Hadoop Hive data from Tableau Desktop, when you try to drag a field into the view or filter data, the following error might occur:
Error from Hive: error code: '1' error message: Error while processing statement: Failed: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MapRedTask


  • Tableau Desktop
  • Hortonworks Hadoop Hive
  • MapR Hadoop
  • Cloudera Hadoop Hive
  • Cloudera Impala


Work with you database administrator to troubleshoot the following database configurations:
  1. Verify that the Hadoop Hive configuration does not contain added properties:
    • Verify that properties allow for SELECT statements with defined fields from tables, for example, SELECT <field_name> FROM <table_name>.
  2. Restart the Hadoop Hive cluster to ensure that the database is not referring to cached configurations or JAR files that no longer exist.


This error is passed to Tableau Desktop from the database. It indicates that there is a problem with the Hadoop Hive database configuration.
Did this article resolve the issue?