Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

String length exceeds DDL length: Truncate string length to Redshift max #163

Open
alok87 opened this issue Mar 12, 2021 · 0 comments
Open

String length exceeds DDL length: Truncate string length to Redshift max #163

alok87 opened this issue Mar 12, 2021 · 0 comments
Labels
bug Something isn't working p3 not urgent, intermittent issue

Comments

@alok87
Copy link
Contributor

alok87 commented Mar 12, 2021

Since Redshift only support 65535 characters if the col as more, then trucate it to Redshift max.

colname         | summary
type            | varchar
col_length      | 65535
err_code        | 1204
err_reason      | String length exceeds DDL length

At present this does not happens, and breaks table load. Also fixes the source should be the permanent fix.
@alok87 alok87 added the bug Something isn't working label Mar 18, 2021
@alok87 alok87 added the p3 not urgent, intermittent issue label Apr 15, 2021
@alok87 alok87 changed the title Truncate string length to Redshift max String length exceeds DDL length: Truncate string length to Redshift max Apr 20, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working p3 not urgent, intermittent issue
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@alok87