Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Highlighted

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
Highlighted

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.

Highlighted

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;
Highlighted

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"

Don't have an account?
Coming from Hortonworks? Activate your account here