topic Re: Error running query in Talend in Talend Studio

Error running query in Talend

Anonymous — Sat, 16 Nov 2024 06:18:52 GMT

I'm having a problem running an update query in Talend. I get the error that is attached. I can run the following query just fine in Snowflake without an issue. I works ok in Snowflake, but not in Talend. I have used other update statements in Talend with snowflake.

update "EMS"."PUBLIC"."PGA_CLEAN_SUBSCRIBED"
SET rydercup_2020 =
replace (rydercup_2020,'"','')
where email_address <> ''

Re: Error running query in Talend

akumar2301 — Fri, 15 Mar 2019 20:41:45 GMT

You have to convert it in java string.

I suggest to create this update query as java string variable and print. You will see the issue.

E.g Your query should start with “ .
If in your query you have “ and it is mandatory it should be escaped like \”EMS

Re: Error running query in Talend

Anonymous — Fri, 15 Mar 2019 21:43:43 GMT

This is what I am running in Talend.

"update "EMS"."PUBLIC"."PGA_CLEAN_SUBSCRIBED"
SET rydercup_2020 =
replace (rydercup_2020,'"','')
where email_address <> ''"

I do have double quotes at the end and the beginning. As I said earlier I
can run the same query without the double quotes in Snowflake, but I then
when I try to run it in Talend I get the error message that I attached
earlier.

Re: Error running query in Talend

DataTeam1 — Fri, 15 Mar 2019 22:11:26 GMT

@gfred try this

"update EMS.PUBLIC.PGA_CLEAN_SUBSCRIBED
SET rydercup_2020 =
replace (rydercup_2020,'" + "\"" + "','')
where email_address <> ''"

Notice that

" - is red coloured

' - is blue coloured