Greenplum: Internal Operator Error During Direct Child Partition Inserts

Products

• VMware Tanzu Data Suite
• VMware Tanzu Greenplum

Issue/Introduction

An INSERT INTO ... SELECT statement fails with an internal operator error when inserting directly into a specific child partition of a partitioned table, while the same statement succeeds when targeting the parent (root) partitioned table.​

Example error:

ERROR: could not find valid operator, lhstype: 1082, rhstype: 1043, strategy number: 2 (cdbpartition.c:4256)

 

Environment

Greenplum Database 6.32.0​

Cause

This is a known product defect in Greenplum 6.x and is planned to be addressed in a future Greenplum release. Please subscribe to this article for updates related to the fix. 

Resolution

Until a permanent fix is available, use the following Workaround:

• Modify ETL and application processes to perform inserts against the parent (root) partitioned table instead of individual child partitions.

Additional Information

Reference:

INSERT Command