Loading data to Teradata

Follow

godwin

• March 05, 2017 00:43

Hi all,

  I've created an Export Job to try loading data into Teradata form a workbook.  In the job it creates a table but it tried to create each field to VARCHAR(8019) and causing an error when multiple fields are created.

Anyone came across this issue?

Thanks

 

 

 

0

• Official comment

  

  Joel Stewart

  • March 06, 2017 16:56

  Hi Godwin, 

  We have seen occurrences of the following exception from Teradata: "Teradata code 3933 The Maximum Possible Row Length in the Table is too Large". Is that the exception that you're seeing? 

  Because of that exception, we do have a special note in our documentation for exporting data to Teradata on this page: https://documentation.datameer.com/documentation/display/DAS60/Exporting+Data#ExportingData-exportingDataExportingData

  In summary, Datameer exports strings with a size of 8019 bytes (maximum size) so if exporting more than 8 string columns it's important that the Teradata target table be created outside of Datameer with the required schema. 

  Comment actions Permalink
• 

  godwin

  • April 11, 2017 15:31

  Thanks Joel.  As long as I use existing table to insert data I don't have this issue.

  0

  Comment actions Permalink

Please sign in to leave a comment.