CSV writing error in Teradata

KNIME Analytics Platform
, , , ,
1

Hi.

I would like to request assistance with an error that occurs when using the DB Writer node to load a CSV file (1,947 rows and 40 columns) into Teradata, connecting via JDBC with the parameters CHARSET = UTF8 and TMODE = TERA in KNIME 5.5.2.

During execution, the following error message appears:

“Execute failed: [Teradata Database][TeraJDBC 20.00.00.10][Error 3933][SQLState HY000] The available data bytes in the table’s perm row exceeded the 1000000 byte limit.”

However, the file I am trying to load does not exceed the limit of 1,000,000 bytes per row.

I would appreciate any guidance in resolving this issue.

02 Configuración Table Writer
02 Configuración Table Writer508×1028 50.2 KB
01 Configuración Table Writer
01 Configuración Table Writer502×971 50.3 KB

2

Hi @liliandsr,

Welcome to the Forum!

This looks like a Teradata limitation rather than a KNIME issue. It’s similar to what is described here.

The error occurs when the table definition exceeds Teradata’s 1 MB-per-row limit for permanent space allocation. This happens during CREATE TABLE execution, before any data is actually written. To resolve it, try reducing the defined column widths to stay under the limit.

Best,
Keerthan

2 Likes