Netezza – [HY000] ERROR: Please issue a groom on table

PureData Powered by Netezza, [HY000] ERROR: Please issue a groom on table, Netezza

[HY000] ERROR: Please issue a groom on table

While altering a Netezza table this error was produce:

  • ERROR [HY000] ERROR: Please issue a groom on table ‘<<TableName>>’, maximum table versions exceeded.

The error was resolve by running these commands on succession:

  1. GROOM TABLE ‘<<TableName>> VERSIONS;
  2. GROOM TABLE ‘<<TableName>> PAGES ALL;

Related References

Groom Table

PureData System for Analytics, PureData System for Analytics 7.2.0, IBM Netezza Database User’s Guide, Netezza SQL command reference, groom table