Support Questions
Find answers, ask questions, and share your expertise

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

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

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

Guru

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

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

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

Explorer

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

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

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;

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

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"