apache / apache/cloudberry

ERROR,""DXL-to-PlStmt Translation: Attribute number 72 not found in project list

Open
#1,867 5 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
1.4k
Forks
247
Avg merge
4d 3h
Merged PRs (30d)
39

Description

Hi Team,

GPORA getting is failed while sharing the title error during executing an SP having a table more than 72 columns.
It is resulting in generating to many spill files and causing slowness:

Image

CB Version: postgres (Apache Cloudberry) 2.1.0-incubating build bdf90c5518f
Please can you confirm as it seems like a bug?

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the stored-procedure failure on Apache Cloudberry 2.1.0 with a table exceeding 72 columns, then trace the DXL-to-PlStmt translation path named in the error. Done means the procedure executes without the “Attribute number 72 not found in project list” error and without generating excessive spill files.

Written by the indexing model from the issue text.

Assessment

Tech stack
c, postgresql
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.