Answer the question
In order to leave comments, you need to log in
Is it possible to not list all fields when describing update and insert in merge?
Hello.
it is necessary to merge 2 tables
for the test wrote such a script
MERGE INTO WAREHOUSE.ALL_EVENTS be
USING WAREHOUSE.BUF_ALL_EVENTS buf ON be.id=buf.id
WHEN MATCHED THEN UPDATE SET
version=buf.version,
time_received=buf.time_received
WHEN NOT MATCHED THEN INSERT
(
id,
version,
time_received
)
VALUES
(
buf.id,
buf.version,
buf.time_received
)
;
Answer the question
In order to leave comments, you need to log in
There is no such possibility, which is obvious from reading the man'a.
https://my.vertica.com/docs/8.1.x/HTML/index.htm#A...
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question