Teradata Database Message 3556 - 3556 - Analytics Database - Teradata Vantage

Teradata® VantageCloud Lake - Analytics Database Messages

Edition
Lake
Product
Analytics Database
Teradata Vantage
Published
October 2022
Language
English (United States)
Last Update
2024-02-26
dita:mapPath
tzr1629746512312.ditamap
dita:ditavalPath
ft:empty
dita:id
vza1585613049811
lifecycle
latest
Product Category
Teradata® Vantage™
Message
Too many columns defined for this table.
Explanation
As a table is modified and fields are dropped and added, each new added field is given a higher column id than any prior column id for the table. The range from highest to lowest column id in a table is restricted, for internal reasons, to SYSMAXFIELDS, which is 2560.
Generated By
GEN modules.
For Whom
End User.
Notes
None
Remedy
If the error occurred during ALTER TABLE, then if a new column is absolutely necessary in the table, the table must be rebuilt. Create a new table with the existing data. If the error did not occur during ALTER TABLE, then the cause must be that some spool file has been defined with too many columns. Examine the query and modify to use fewer columns.