topic tImpalaRow component not failing on query failure in Talend Studio

tImpalaRow component not failing on query failure

Vishu1 — Sat, 16 Nov 2024 01:29:14 GMT

Hi,

I am using tImpalaRow component to insert data in a table on its logs I am getting the error/exception printed but the component doesn't fail and execution continue with the next component in the flow.

I have used OnSubJobOK on the tImpalaRow component. On console getting below exception but component did not failed.

Exception in the component tImpalaRow_2:ParseException: Syntax error in line 1:

...value1,INTERVAL,insert_date FROM customers....

Encountered: COMMA

Expected: CASE, CAST, DEFAULT, EXISTS, FALSE, IF, INTERVAL, LEFT, NOT, NULL, REPLACE, RIGHT, TRUNCATE, TRUE, IDENTIFIER

CAUSED BY: Exception: Syntax error

Re: tImpalaRow component not failing on query failure

Anonymous — Mon, 14 Sep 2020 09:31:12 GMT

Hello,

Could you please save your job firstly and re-open it to see if there is any error red X mark in tImpalaRow component?

Please also check your "Code" tab in your job to see if there will be your compile error highlighted in red line.

Best regards

Sabrina

Re: tImpalaRow component not failing on query failure

Vishu1 — Mon, 12 Oct 2020 08:50:59 GMT

There is no error. Actually jobs are running fine. but in case of any error related to impala query then it is not failing that impala component. like in above example impala query failed at 'Interval' keyword but control flows to next component where i use onComponentOk ideally it should execute onComponentError

Re: tImpalaRow component not failing on query failure

Anonymous — Tue, 13 Oct 2020 08:32:14 GMT

Hello,

OnComponentOK will only trigger the target component once the execution of the source component is complete without error. Its main use could be to trigger a notification subJob for example.

OnComponentError will trigger the subJob or component as soon as an error is encountered in the primary Job.

Here is related reference: TalendHelpCenter: Connection types

Best regards

Sabrina