Query Error "No Plan has been Computed for Required Properties"

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

This article provides guidance for troubleshooting the following error seen when using the Pivotal Query Optimizer (PQO) also known as ORCA in either Pivotal Greenplum or Pivotal HDB:

2017-02-02 20:00:42:638492 JST,THD000,ERROR,""CErrorHandlerStandard.cpp:75: No plan has been computed for required properties"",",,,,,,"select XXXX,"COptTasks.cpp",555,

 

The above error would be seen in the master log.

 

Environment

Cause

The error means that the PQO could not compute a plan for the query. PQO is still actively developed and frequently improved and it is the expected behavior that we fall back to the Legacy planner when PQO can't perform an operation or find a suitable plan for a given query.

 

Resolution

Although there isn't any permanent fix for this yet except falling back to the Legacy planner, the following information would be helpful for our development team in order to continue improving the PQO:

A. Does the query return results even if you see this error?
B. Collect an EXPLAIN and EXPLAIN ANALYZE output for the affected query.
C. Collect an Optimizer Minidump File generated by the affected query. The minidump files describes the optimisation context for a given query and helps us analyse query optimizer problems. To collect the minidump, you can follow the steps below:

1. Login into the database via PSQL: psql <database_name>
2. Enable the Optimizer Minidump generation on a session level: set optimizer_minidump = always
3. Run the affected query: select column from table where...
4. Exit PSQL: \q
5. Collect the .mdp file that was generated in the master data directory: ls $MASTER_DATA_DIRECTORY/minidumps/*.mdp