AppendOnly table reports "append only table version -1" in Pivotal Greenplum

Products

• VMware Tanzu Greenplum

Issue/Introduction

When running REORGANIZE=true on an AppendOnly (AO) table the error "append only table version -1" is reported.

Environment

Product Version: 5.21

Resolution

To resolve this issue, run reindex against the table:

REINDEX TABLE <schema>.<table>;