topic Reserved word in my postgres query throws an error in tPostgresqlRow in Talend Studio

Reserved word in my postgres query throws an error in tPostgresqlRow

Anonymous — Fri, 01 Mar 2019 16:02:50 GMT

Hi,

I'm very new on Talend Open Studio for Data Integration version 7. I have a query that throws an error. How do you resolved reserved words in the query that runs throus tPostgresqlRow?

Select "current_schema", src_id from src_table

Thanks in advance!

Re: Reserved word in my postgres query throws an error in tPostgresqlRow

Anonymous — Fri, 01 Mar 2019 16:37:31 GMT

You need to escape the double quotes that you use to escape the reserved words. So, something like this....

"Select \"current_schema\", src_id from src_table"

The reason for this is that the queries used in Talend are actually Java Strings. Java Strings are surrounded by double quotes. To include a double quote, you need to escape it with a \.

Re: Reserved word in my postgres query throws an error in tPostgresqlRow

Anonymous — Fri, 01 Mar 2019 16:48:04 GMT

Thank you...

I also have a followup question.

In tDBInput_1, I select all current_schema and src_sys_id and pass it through tFlowtoIterate_1. Then I have tDBInput_4 that selects my input table and use the current_schema from tDBInput_1. Whenever I run this, it's always null. I'm going crazy figuring this out.

Re: Reserved word in my postgres query throws an error in tPostgresqlRow

Anonymous — Fri, 01 Mar 2019 17:46:24 GMT

There are a couple of things wrong where you use your globalMap. First of all, the tFlowToIterate names the globalMap key using the row that feeds it and the column name. The row that feeds it is row4 not row1. The other issue is that you will need to cast that value from Object. The globalMap will default all objects to Object. To do this, just use the following code....

((String)globalMap.get("row4.current_schema"))