Support Questions

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

Tez Engine is failing while running hive query, with below error. Please help ?

New Contributor

hive> SELECT COUNT(*) FROM student;

Query ID = 3d50f624-68eb-48b5-a0c4-33697da38e91

Total jobs = 1

Launching Job 1 out of 1

Tez session was closed. Reopening...

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask

hive>

,

hive> SELECT COUNT(*) FROM student;

Query ID = 3d50f624-68eb-48b5-a0c4-33697da38e91

Total jobs = 1

Launching Job 1 out of 1

Tez session was closed. Reopening...

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask

hive>

4 REPLIES 4

Guru

you can launch hive in a debug session mode to have more info

hive --hiveconf hive.root.logger=INFO,console 

Explorer

Check /tmp/hive for hive log and you will see the error stacktrace there.

Contributor

Try changing the execution engine to MR.. Run your query.. If its working fine. Change the execution engine to tez.

this is how you do it.

set hive.execution.engine=mr;

set hive.execution.engine=tez;

Explorer

are you on hive2? if yes try providing queue name to the host

beeline -u jdbcLhive2://<localhost>:10000?ez.queue.name=<queuename> -n hive -e "select count(*) from student"

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