question Re: Hortonworks Hive 35 Error in Support Questions

Hortonworks Hive 35 Error

hughes87 — Wed, 19 Oct 2022 17:13:53 GMT

When I attempt to' join' tables or even use 'group by', I get the following error:

Hortonworks Hive DSN -- [Hortonworks][Hardy] (35) Error from server: error code: '1' error message: 'Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask'.(HY000,35)

Yet, I am able to do a simple 'select-from-where' query with no problem.

I am using the IDE Rapid SQL.

Any idea of what is going on?

Re: Hortonworks Hive 35 Error

ggangadharan — Sat, 30 Sep 2023 18:36:49 GMT

It seems that the failure occurred within the Tez job's child tasks. To identify the root cause, please share the YARN logs of the failed application

Re: Hortonworks Hive 35 Error

DianaTorres — Tue, 03 Oct 2023 21:02:29 GMT

@hughes87 Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. If you are still experiencing the issue, can you provide the information @ggangadharan has requested? Thanks.

Re: Hortonworks Hive 35 Error

KermitTheFrog — Fri, 30 Aug 2024 09:55:17 GMT

Hello, have you manage to resolve your problem?

Cause I have the same. Via ODBC Simple Select works just fine, but something more complicated like nested SQL, PARTITION etc drop the same error.

But the same SQL running perfect without errors in Hue.

Thanks.

Re: Hortonworks Hive 35 Error

ggangadharan — Tue, 03 Sep 2024 05:22:27 GMT

Since the failure occurred within the Tez job's child tasks, please share the yarn log or complete Stacktrace from one of the failed child task attempts. This will help us identify the root cause of the failure and provide appropriate recommendations to resolve the problem.

Re: Hortonworks Hive 35 Error

KermitTheFrog — Wed, 04 Sep 2024 11:46:04 GMT

Hello ggangadharan, want to share my solution. After adding correct tez.queue.name prod value in ODBC advanced server connection options - everything started working like a charm.

Re: Hortonworks Hive 35 Error

ggangadharan — Wed, 04 Sep 2024 12:35:51 GMT

If setting the proper queue name resolves the problem, it is possible that the query may have been submitted in the default queue, where it competes for resources with other queries and fails due to a timeout error