Target lists can have at most 1664 entries

Moderator: NorbertKrupa

Post Reply
vcarusi
Beginner
Beginner
Posts: 29
Joined: Mon Apr 20, 2015 11:03 am

Target lists can have at most 1664 entries

Post by vcarusi » Tue Dec 08, 2015 4:31 pm

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

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Target lists can have at most 1664 entries

Post by JimKnicely » Wed Dec 09, 2015 11:16 pm

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 :)
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

vcarusi
Beginner
Beginner
Posts: 29
Joined: Mon Apr 20, 2015 11:03 am

Re: Target lists can have at most 1664 entries

Post by vcarusi » Thu Dec 10, 2015 9:35 am

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

Post Reply

Return to “General”