Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Tez ERROR when running hive queries from Zeppelin through jdbc connector

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(
	at org.apache.hive.jdbc.HiveStatement.execute(
	at org.apache.commons.dbcp2.DelegatingStatement.execute(
	at org.apache.commons.dbcp2.DelegatingStatement.execute(
	at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(
	at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(
	at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(
	at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(
	at org.apache.zeppelin.scheduler.ParallelScheduler$
	at java.util.concurrent.Executors$
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(
	at java.util.concurrent.ScheduledThreadPoolExecutor$
	at java.util.concurrent.ThreadPoolExecutor.runWorker(
	at java.util.concurrent.ThreadPoolExecutor$

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.


New Contributor

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

New Contributor

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 before executing the query in zeppelin and the issue is resolved now.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.