topic Re: tbigquerysqlrow component - Multiple queries issue in Talend Studio

tbigquerysqlrow component - Multiple queries issue

Anjali3 — Sat, 16 Nov 2024 04:09:33 GMT

Hi ,

Im trying to execute tbigquerysqlrow component with Multiple statements.(with delete and insert or delete and delete).

But i get null pointer exception when i execute the job. Does this component allows multiple select statements , if yes what is the syntax. Thank you

Re: tbigquerysqlrow component - Multiple queries issue

Anonymous — Fri, 08 Nov 2019 05:36:54 GMT

Hi,

I faced the same issue a while ago. It was because of the connection wasn't successful. You can check for the error by printing ((String)globalMap.get("tBigQueryInput_1_ERROR_MESSAGE")). Make sure all the credentials are correct.

Hope this helps.

Regards

Re: tbigquerysqlrow component - Multiple queries issue

Anjali3 — Fri, 08 Nov 2019 05:49:12 GMT

Hi ,

Thanks for your reply. I tried printing. But it says null. Below is the syntax im trying to run. Moreover with single query. It is running fine. So connection details should be fine. Let me know if this syntax holds good for multiple queries.

"delete from `projectname.datasetname.tablename1` where 1=1;
"delete from `projectname.datasetname.tablename2` where 1=1;

Re: tbigquerysqlrow component - Multiple queries issue

Anjali3 — Fri, 08 Nov 2019 05:51:02 GMT

Sorry there is type o in previous query. Below is the one tried.

"delete from `projectname.datasetname.tablename1` where 1=1;
delete from `projectname.datasetname.tablename2` where 1=1"

Re: tbigquerysqlrow component - Multiple queries issue

Anonymous — Fri, 08 Nov 2019 05:57:18 GMT

Hi,

Could you try using following query(without single quotes):

"delete from projectname.datasetname.tablename1 where 1=1;
delete from projectname.datasetname.tablename2 where 1=1;"

And for the worst case, try using column name in the condition.

Eg. delete from <table_name> where <table_name.column=condition>

May be it is not getting the value for column when you are using the number. (Just a thought. Not sure about this. But no harm in trying, right?)

Regards.

Re: tbigquerysqlrow component - Multiple queries issue

Anjali3 — Fri, 08 Nov 2019 06:21:37 GMT

Tried using both conditions you mentioned. No luck . If i remove the quotes , it is throwing compilation error.

and used where clause in delete statement , still it throws null pointer exception.

Note : Combination of Insert and select or both select statements also throwing same issue.

Re: tbigquerysqlrow component - Multiple queries issue

Anonymous — Fri, 08 Nov 2019 06:23:18 GMT

Did you use a trigger onSubjobOk after the connection component before the component which executes the queries? If not, please use it. It helps.

Re: tbigquerysqlrow component - Multiple queries issue

Anjali3 — Fri, 08 Nov 2019 07:10:38 GMT

Hi ,

Thank you so much. Tried on component ok with bigquerysqlrow component. Worked fine. Thanks for saving my time

Re: tbigquerysqlrow component - Multiple queries issue

Anonymous — Fri, 08 Nov 2019 07:13:29 GMT

Happy to help!

If it worked, you can accept it as solution. So that if anyone else has the same issue, can refer it.

Don't forget to give kudos if the reply worked!

Regards.