I am trying to create a table with app. 400 columns, out of which most of them are 'Varchar'. But I am getting an error as-3933 'Max row length exceeded'. I kept the minimum column width for all the columns. I cannot reduce the column widths further as it will impact while loading the data.
Any solution for this issue?
I also use the data in this table for downstream loading and comparisions. Please let me know for any solutions.
Thanks in Advance !
the maximum size of a row in Teradata is limited to a bit less than 64k bytes, for a VarChar the defined maximum length (*2 if it's Unicode) will be used for the row length calculation.
If you can't reduce the size you're out of luck.
400 columns, mostly VarChars, sound like a strange data model, where's this data coming from?