Greenplum: Internal Operator Error During Direct Child Partition Inserts
search cancel

Greenplum: Internal Operator Error During Direct Child Partition Inserts

book

Article ID: 433207

calendar_today

Updated On:

Products

VMware Tanzu Data Intelligence VMware Tanzu Gemfire VMware Tanzu Greenplum VMware Tanzu Data Suite VMware Tanzu Data VMware Tanzu RabbitMQ RabbitMQ VMware Tanzu for MySQL VMware Tanzu for Postgres VMware Tanzu for Valkey

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