Hi, I am creating a sample CDC on greenplum DB using postgres components but i i am facing issue on running mapping after creating CDC on the table. Please suggest about below issue. Exception in component tPostgresqlOutput_3 org.postgresql.util.PSQLException: ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg19 alpsdw5gp1dev.idc.ge.com:1028 pid=451468) (cdbdisp.c:1326) Detail: SQL statement "INSERT INTO "prod_test"."TCDC_films_test" ( "TALEND_CDC_SUBSCRIBERS_NAME", "TALEND_CDC_STATE", "TALEND_CDC_TYPE", "TALEND_CDC_CREATION_DATE", "code" ) SELECT "TALEND_CDC_SUBSCRIBER_NAME", '0', 'U', CURRENT_TIMESTAMP, $1 FROM "prod_test"."TSUBSCRIBERS" WHERE "TALEND_CDC_TABLE_TO_WATCH"='prod_test.films_test'"
Hi,
Did you follow up document about:
TalendHelpCenteretting up a CDC environment to set up CDC environment for your Postgresql DB?
Could you please on which build version you got this issue?
Best regards
Sabrina
Hi Sabrina,
Thanks for the response.
I am using Talend 5.6.1 version.
I am trying to perform CDC on trigger mode and followed the provided link.Database in greenplum database as the greenplum database doesn't have direct component like oracle (tOracleCDC), I am using tPostgresqlCDC. Created CDC connection and established table schemas along with TSUBSCRIBERS, as mentioned in the link tried to "view all Changes" no rows are found,