Teradata Database Message 8232 - 17.10 - 8232 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
Cannot build re-hashed table with AMP off-line
Explanation
Non-fallback protected tables cannot be built when an AMP is off-line if the rows need to be re-hashed. Rows can be initially loaded but they cannot be properly re-hashed and sorted until all AMPs are up.
Generated By
HUTBLD Amp procedure.
For Whom
End User.
Notes
None
Remedy
The utility will report the error and skip to the next table to be processed. Later, you need to bring the bad AMP back on-line and perform an explicit BUILD NO FALLBACK operation.