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
Target lists can have at most 1664 entries
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Target lists can have at most 1664 entries
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
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Target lists can have at most 1664 entries
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
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