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