Skip to content

Teradata Destination: Teradata Destination connector is not handling columns of data types with >1000 chars #134

Description

@libellule-117

Connector Name

destination-teradata

Connector Version

0.2.1

What step the error happened?

During the sync

Relevant information

I am trying to write data from s3 (parquet) to Teradata with Airbyte.
For data type string with a very large number of characters (>1000) I get an error:

java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: [Teradata Database] [TeraJDBC 20.00.00.32] [Error 7548] [SQLState HY000] Actual result length exceeds expected result length.

The connection works when I exclude the column.
If I create the table manually in Teradata with a larger varchar field, I get the same error.

Relevant log output

java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: [Teradata Database] [TeraJDBC 20.00.00.32] [Error 7548] [SQLState HY000] Actual result length exceeds expected result length.

Contribute

  • Yes, I want to contribute

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions