数据仓库服务 GaussDB(DWS)-DWS元数据不一致-分区索引异常:处理方法

时间：2025-02-12 15:02:21

处理方法

删除该表索引信息。
1

DROP INDEX a_0317_index;

对该表索引进行重建。

    
         CREATE INDEX a_0317_index on a_0317(a) local (partition p1_index, partition p2_inde);

查看表定义无报错。

    
         \d+ a_0317                        Table "public.a_0317" Column |  Type   | Modifiers | Storage | Stats target | Description--------+---------+-----------+---------+--------------+------------- a      | integer |           | plain   |              |Indexes:    "a_0317_index" btree (a) LOCAL(PARTITION p1_index, PARTITION p2_inde)  TABLESPACE pg_defaultRange partition by(a)Number of partition: 2 (View pg_partition to check each partition range.)Has OIDs: noDistribute By: HASH(a)Location Nodes: ALL DATANODESOptions: orientation=row, compression=no