topic Re: Talend Job Redshiftrow Copy Command Error in Talend Studio

Talend Job Redshiftrow Copy Command Error

Anonymous — Sat, 16 Nov 2024 08:40:06 GMT

Hi ,

Can anybody help me,while i am running talend job with copy command its throwing error like:

insufficient data left in message during my COPY from S3 to Redshift.

Can anybody help me.

Regards,

Prasanth

Re: Talend Job Redshiftrow Copy Command Error

vapukov — Wed, 21 Feb 2018 07:09:22 GMT

why You still do not want check what redshift think about this?
https://docs.aws.amazon.com/redshift/latest/dg/r_STL_LOAD_ERRORS.html

just

select * from stl_load_errors order by starttime desc;

It can give You more information about error

Re: Talend Job Redshiftrow Copy Command Error

Anonymous — Wed, 21 Feb 2018 17:22:55 GMT

Thank you vapukov.

Now i am getting different error which is "extra columns found". while loading data into redshift from s3.

could you please help me.

Thank you.

Re: Talend Job Redshiftrow Copy Command Error

vapukov — Wed, 21 Feb 2018 21:50:40 GMT

@PALIVELATalend wrote:

Thank you vapukov.

Now i am getting different error which is "extra columns found". while loading data into redshift from s3.

could you please help me.

Thank you.

answer already in Your question

investigate Your data! it mean:

- data do not proper escaped

- one(few) of rows contain separator character in column value, like

this is somedata, about something
this is another ~ similar data

1st will be detected as 2 column with "," separator, 2nd with "~" separator