SQL Error [XX000]: ERROR: could not find hash distribution key expressions in target list
search cancel

SQL Error [XX000]: ERROR: could not find hash distribution key expressions in target list

book

Article ID: 426014

calendar_today

Updated On:

Products

VMware Tanzu Data Suite VMware Tanzu Greenplum VMware Tanzu Greenplum / Gemfire VMware Tanzu Data Suite

Issue/Introduction

When creating a table Greenplum might fall back Postgres Planner and report the error:

SQL Error [XX000]: ERROR: could not find hash distribution key expressions in target list

Resolution

Fixed in Greenplum 7.7.1 and above.

Powered by Wolken Software