I have a workflow that works when running it locally. However when I schedule it using the server I get the below error message.
The workflow did not fully execute.
The following messages were collected:
ERROR Database Connection Table Reader 31:39: Execute failed: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask
Here are my Hive Connector Credentials
It could be that on your Big Data server your (KNIME) user must be allowed to impersonate your big data user.
Maybe @tobias.koetter can weight in on this.
mlauber71 might be right that your KNIME Server is not properly setup to do impersonation. For more details about the setup have a look at the Secured Cluster Connection Guide. If this isn’t the problem please send me you full KNIME log with the error message via private message in the forum or contact the KNIME support since the error message you posted is to unspecific to identify the problem.