What is Merge out?

What's difference Merge out and Merge into??

Best Answers

  • Jim_KnicelyJim_Knicely Administrator
    edited September 12 Accepted Answer

    @HyeontaeJu is probably refering to the MERGE SQL statement (i.e. MERGE INTO...)

    Doc Page:
    https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Statements/MERGE.htm

  • yun_hoe_kimyun_hoe_kim Employee
    Accepted Answer

    Merge out and Merge into are totally different and has no relation at all.
    Remember Vertica creates new container per table per load. Merge out is to consolidate multiple containers into a single container for better read performance of database.
    Merge into is a SQL statement that performs update (if data exists on target table) and insert (if data not exists on target table) at the same time to consolidate data from SQL level. You can refer details for merge into statement from the URL Jim has posted earlier.

Answers

  • Mergeout is a Tuple Mover process that consolidates ROS containers and purges deleted records. There is no function called Merge into in Vertica.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.