Teradata Database Message 8232 - 8232 - Analytics Database - Teradata Vantage

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.