调用getIndexInfo函数时会通过jdbc查询TD表获取表的index信息,有时候报错如下:
java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 13.00.00.07] [Error 822] [SQLState HY000] TeraDatabaseMetaData: getIndexInfo : Failed to create result set. Index = 1 and rowIndex = 0. [Teradata Database] [TeraJDBC 13.00.00.07] [Error 7535] [SQLState HY000] Operation not allowed: <Schema>.<Table> table header has invalid partitioning.
需要执行以下语句:
ALTER TABLE <databasename.tablename> REVALIDATE PRIMARY INDEX;
重新恢复数据字典后分区表需要REVALIDATE PRIMARY INDEX