Error running query in Talend

[Anonymous]

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 <> ''

[Anonymous]

This is the query that I am running.  

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

As I said earlier it does run ok and eliminates the double quotes at the beginning, but it does not eliminate the double quotes at the end.  

[Anonymous]

Hi,

I could not see any problem with our query.

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

Could you please add it in your target tDBOutput and then toggle to code part of Talend? It will show if there is any syntax error.

The error might be some other component also where you must have accidentally forgotten to close any quotes.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

I never said that it had an error.  The problem is that the data is enclosed by double quotes.  An example is "Whistling Pines".  The query removes the double quotes at the beginning of the data such as, Whistling Pines".  But it leaves the double quotes at the end of the data.