What is Merge out?

HyeontaeJuHyeontaeJu Vertica Customer

What's difference Merge out and Merge into??

Best Answers

  • Options
    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:

  • Options
    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.


  • Options
    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
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file