Talend : tRedShiftRow error : Unable to interpret the update count in
Hi,
I am running an RedShift Insert query in Talend using tRedShiftRow component.
Java Exception;tRedshiftRow_22;org.postgresql.util.PSQLException:Unable to interpret the update count in command completion tag: INSERT 0 2168439549.;1
I googled and found some documentation for this error :
Outsourcer uses Java and in doing so, the INSERT statement uses the Statement Class and the executeUpdate method. The executeUpdate is used for INSERT, UPDATE, or DELETE and returns the number of rows impacted by the statement as an int. In Java, an “int” is defined with a maximum of 2,147,483,647. This means if your SQL statement affects more than 2.1 Billion rows, then Java will throw an error.
Has anyone error got this error? How to fix this is Talend?
Thanks!
J
tredshiftrow22 -> row24(Main) - >tredshiftrow23
tredshiftrow22 has an insert and update statement which may sometimes affect more than
2.1 Billion rows.
When that happens, the talend returns and error and fails with error "
Unable to interpret the update count in command completion tag: INSERT 0 2233627970.;1 "
Is there a way to suppress this error in Talend?