It is not a Talend error message it is Redshift (Postgres)
You can check, what happens exactly by select data from sql_load_errors:
select
d.query,
substring(d.filename,14,20),
d.line_number as line,
substring(d.value,1,16) as value,
substring(le.err_reason,1,48) as err_reason
from stl_loaderror_detail d, stl_load_errors le
where d.query = le.query and d.query = pg_last_copy_id();
But,i am able to run same copy command from Redshift and i am able to load data into redshift from S3. Where as using Talend i am unable to load data into redhsift,throwing error like : [Amazon](500310) Invalid operation: insufficient data left in message;
Same == prepared by talend, transferred to S3 and then imported by Redshift? or it "similar" data? (which You trust look same ... but we not trust nobody )
Same data i used.When i am using copy command which is ran successfully into redshift.while i am trying to load same data using talend,some how it throwing an error on talend.
source file delimiter is '~' .
Also,please find below copy command which i used for redshift load.
