Teradata In-DB "Data Stream In" tool Error

Hi,

I am using In-DB "Data Stream In" tool to bring in 1M rows into Teradata. I am using "Overwrite Table" in the creation mode. I am getting the following error when i run the workflow:

DataWrap2ODBC::SendBatch:[Teradata][ODBC Teradata Driver]SQL request exceeds maximum allowed length of 1 MB Insert into "databasename"."tablename"("columnname") Values

I tested the write by limiting the rows to 20,000 and i get this error:

DataWrap2ODBC::SendBatch: [Teradata][ODBC Teradata Driver][Teradata Database] Too many data records packed in one USING row. Insert into "databasename"."tablename"("columnname") Values

It looks like i cannot write more than 16,383 rows. If i limit to this then it's successfull. If i changeto 16,384 then it ends in error with the above message.

Please advise.

Workflow

Datasets

Input

Server

Bug

Optimization

In Database

Data Investigation

Database Connection

In-Database

Accepted answers

dineshp

Issue resolved after reinstallation of SQL Assist 10.50 and increasing the commit transaction size to 16,383.

All comments

Thableaus

Hi @dineshp

Why don't you use a regular Output Tool to create this table? Is there any reason for that?

The first error is due to the length of your SQL statement. When Alteryx converts your data to a SQL statement to create the table in Teradata, this statement is probably too long. This might be due to the fact your insert clause is taking in consideration too many rows.

Which version of ODBC driver are you using? And which teradata database version are you in?

Cheers,

dineshp

Hi @Thableaus

This is a part of workflow. I am trying to bring it inside In-DB for my workflow (That's why Stream In tool). I am not writing any sql statement everything is automatically carried out by Alteryx. It works for 2 of my colleagues. Not sure what's wrong. We all have identify drivers and setup.

Teradata & Driver is 15.10 version

dineshp

Issue resolved after reinstallation of SQL Assist 10.50 and increasing the commit transaction size to 16,383.

davidhenington

@dineshp have you streamed into TD as a temp table? If yes, did you have to get special permissions from the DBA?

Would be curious to hear you experience.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703