Skip to content

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

@libellule-117

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

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