The Vertica Database Forums

Hi,
I have 2 tables with 971 columns.
The first one has 12,700,000 records, the second one is empty.
I need to run a MERGE in order to fill/update the second table.
The error is : ERROR 4913: Target lists can have at most 1664 entries
Where can I find information about this error ?
Thank you,
Veronica

Hi,

What version of Vertica are you running? That's a PostGreSQL error message (Vertica uses the PostGreSQL parser).

Did you include all of the 974 columns in the INSERT and all 974 columns in the UPDATE part of the MERGE statement?

That's be 974+974=1948 targets, where the max. is 1664.

Maybe try using two MERGE commands? One for 487 columns and another for the other 487 columns?

However, better yet, don't create such a WIDE table

Hi,
Thank you for your response.
The version is Vertica Analytic Database v7.1.1-0 .

MERGE only with UPDATE , 971 columns, works.
MERGE only with INSERT, 971 columns, doesn't work.
MERGE only with INSERT, 26 columns, works.
INSERT (971 columns) SELECT 971 columns FROM, works.

Probably is a limitation of MERGE stmt.
Veronica