KNOWLEDGE BASE

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


Published: 03 Oct 2013
Last Modified Date: 10 Jul 2014

Issue

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

Environment

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

Resolution

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.

Cause

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?