Support Questions

Find answers, ask questions, and share your expertise

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

avatar
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

avatar
Guru

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

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

avatar
Contributor

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

avatar
Rising Star

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;

avatar
Contributor

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"