Tez ERROR when running hive queries from Zeppelin through jdbc connector

[#1]

When running simple queries [select * from table] from a Zeppelin Notebook I'm having no issues and the query shows me the contents of the table.

When I try to run a query that requires any calculation like [select count(*) from table] from the same Zeppelin Notebook I get a Tez ERROR:

java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask
	at org.apache.hive.jdbc.HiveStatement.waitForOperationToComplete(HiveStatement.java:354)
	at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:245)
	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
	at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:682)
	at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:763)
	at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:101)
	at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:502)
	at org.apache.zeppelin.scheduler.Job.run(Job.java:175)
	at org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
<br>

When I run the same queries from the hive interpreter in console, the query runs without trouble and show me the results, so we can say it is a problem with the jdbc driver.

[#2]

Did you try setting the default.user and default.password in the jdbc interpreter setting for zeppelin?

[#3]

To get the actual root cause please check the hiveserver2.log from the node there hiveserver2 is running.

In our case it was the respective user was not having access to default queue and we make the user to explicitly set tez.queue.name before executing the query in zeppelin and the issue is resolved now.