topic Re: Error running query in Talend in Talend Studio

Error running query in Talend

Anonymous — Sat, 16 Nov 2024 06:18:50 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

Anonymous — Sat, 16 Mar 2019 08:41:07 GMT

Hi,

It seems you have created two posts for same query. Please refrain from creating multiple posts for same query as it will dilute the focus of Talend community members.

Since your other thread is more active and lot of solutions are already there, could you please close the current post?

https://community.talend.com/t5/Design-and-Development/Error-running-query-in-Talend/m-p/154819#M94665

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 🙂

Re: Error running query in Talend

Anonymous — Mon, 18 Mar 2019 13:37:31 GMT

I tried the solution. It only works partly. It does remove the double quotes at the beginning of the field, but it does not remove the double quotes at the end of the field.

Re: Error running query in Talend

Anonymous — Mon, 18 Mar 2019 14:59:13 GMT

Hi,

Could you please share a sample record in code section, the Talend code you are using to do the task the current output?

Please share the screen shots of the conversion component.

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 🙂

Re: Error running query in Talend

Anonymous — Mon, 18 Mar 2019 15:21:57 GMT

I just added the project

EMS_PGA_Clean_Subscribers.zip

Re: Error running query in Talend

Anonymous — Mon, 18 Mar 2019 15:22:40 GMT

Here's a screen print.

Talend code example.PNG

Re: Error running query in Talend

Anonymous — Mon, 18 Mar 2019 15:28:58 GMT

Here's a partial input file.

cleaned_members_export_52e91289a2-version2.txt

Re: Error running query in Talend

Anonymous — Mon, 18 Mar 2019 16:16:12 GMT

Hi,

I could see that you have not given escape character to double quote.

Could you please try like below and let us know the results?

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 🙂

Re: Error running query in Talend

Anonymous — Mon, 18 Mar 2019 19:12:57 GMT

I'm confused as that is a copy of the query that I was sent earlier. Now you are saying that it shouldn't work?

Re: Error running query in Talend

Anonymous — Tue, 19 Mar 2019 04:32:42 GMT

In your earlier query, you have not marked the double quotes as escape character. So your query must be breaking mid way.

Did you check the results after including the escape character?

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 🙂

Re: Error running query in Talend

Anonymous — Tue, 19 Mar 2019 13:15:12 GMT

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.

Re: Error running query in Talend

Anonymous — Tue, 19 Mar 2019 14:56:29 GMT

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 🙂

Re: Error running query in Talend

Anonymous — Tue, 19 Mar 2019 15:08:11 GMT

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.