Hive Component is not working properly

[Anonymous]

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.

[Anonymous]

SOLVED.

The problem was on another component.

If possible, delete this post @xdshi 

Thanks.

[Anonymous]

Hello,

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

Best regards

Sabrina

[simo2]

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

Thanks

[simo2]

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

thanks

[Anonymous]

Hello Simo,

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

Best regards

Sabrina