topic Hive Component is not working properly in Talend Studio

Hive Component is not working properly

Anonymous — Sat, 16 Nov 2024 06:16:14 GMT

Hello. We are facing an issue when using the component tHiveInput (the same happens for tHiveRows)

Talend Data Fabric 6.4.1

When I run a query without functions, the job works as it should (follow image as example)

Query: "SELECT date
FROM schema.table_bla
WHERE bla in ('1','2')"

(The other fields are supposed to be null, it was just an example)

but when I run the query with functions (tried min, max, count, distinct) it doesn't work.. It sends the query to HADOOP, but it's state stay as ACCEPTED, but never changes to RUNNING, and it stays like this for around 30 minutes and then the job just die..

Follow the image of the Talend Error I get

And here the spark process at Job Browser as ACCEPTED for more than 9 minutes (and it says like this for around 30 minutes)

Follow the image of the tHiveInput component with the query I ran.

Thanks in advance,

César.

Re: Hive Component is not working properly

Anonymous — Fri, 22 Mar 2019 18:30:23 GMT

SOLVED.

The problem was on another component.

If possible, delete this post @xdshi

Thanks.

Re: Hive Component is not working properly

Anonymous — Mon, 25 Mar 2019 03:38:49 GMT

Hello,

Are you using other Hive and RDB components in your work flow?

Best regards

Sabrina

Re: Hive Component is not working properly

simo2 — Mon, 01 Mar 2021 17:38:16 GMT

Hello, what was the source of the issue please ? i have the same error message

Thanks

Re: Hive Component is not working properly

simo2 — Mon, 01 Mar 2021 17:39:18 GMT

hello Sabrina, i have the same issue . can you help me please ?

thanks

Re: Hive Component is not working properly

Anonymous — Wed, 03 Mar 2021 07:35:28 GMT

Hello Simo,

Could you please create a new thread/topic for your issue? More information will be preferred.

Best regards

Sabrina