View fallback to Planner after dropping or adding columns

Products

• VMware Tanzu Greenplum
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite

Issue/Introduction

When running queries with views, after dropping or adding columns in any of the tables used by the view you are seeing the following error which reports that the query is falling back to Planner:

ERROR,""Query-to-DXL Translation: No variable entry found due to incorrect normalization of query""

Resolution

There is an issue in the translator where it failed to properly account for dropped columns while constructing VAR to DXL mapping. Even though the dropped column is not explicity referenced in the SQL query, it is still referenced in the parsed query before being sent to the Optimizer.

The issue is currently being worked on and should be fixed in Greenplum version 6.29.1 and above