What is Merge out?

HyeontaeJuHyeontaeJu Vertica Customer ✭
in General Discussion

What's difference Merge out and Merge into??

Best Answers

  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited September 2020 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 Vertica Employee Employee
    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

  • Nimmi_guptaNimmi_gupta - Select Field - Employee

    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...