topic Re: Error while fetching data from Greenplum in Talend Studio

Error while fetching data from Greenplum

MahiwalVinit — Sat, 16 Nov 2024 09:16:59 GMT

I am fetching data from Greenplum using a complex SQL with multiple union in the query, and writing it to Haddop. I am using tGreenplumInput component. While fetching data getting error

Exception in component tGreenplumInput_1
org.postgresql.util.PSQLException: ERROR: syntax error at or near "8"
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)

Able to execute query successfully on using aginity but getting error with greenplum component.

How to resolve this

Re: Error while fetching data from Greenplum

Anonymous — Mon, 18 Sep 2017 06:42:52 GMT

Hi,

Could you please also show your complex SQL with multiple union query?

Exception in component tGreenplumInput_1
org.postgresql.util.PSQLException: ERROR: syntax error at or near "8"
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)

Is there any compile error highlighted in red line when you check your "Code" tab in your job?

Best regards

Sabrina

Re: Error while fetching data from Greenplum

MahiwalVinit — Tue, 19 Sep 2017 11:07:57 GMT

Hi
here is query
https://paste.ofcode.org/WEER8iijprWNwgfrrwb675
please check it.
I have converts it to execute in talend by replacing " by \"

Re: Error while fetching data from Greenplum

MahiwalVinit — Mon, 25 Sep 2017 14:37:15 GMT

I am able to resolve the issue now.
It is due to '\\' used in the query. Talend is not able to understated '\\'.
Therefore instead of '\\' needs to use '\\\\' in the tGreenplumInput component.

Re: Error while fetching data from Greenplum

Anonymous — Tue, 26 Sep 2017 10:55:19 GMT

Hello,

Thanks for posting that you have resolved this issue by yourself.

Best regards

Sabrina