What happens when INSERT/DELETE/UPDATE/COPY run on a secondary subcluster?

Deb_ChatignyDeb_Chatigny Administrator
edited April 2 in General Discussion

What happens when INSERT/DELETE/UPDATE/COPY run on a secondary subcluster? Will the client get a warning/error?
@skeswani , @skamat
Sizing and Configuring Vertica in Eon Mode for Different Use Cases

Answers

  • ybeiybei Employee

    it should work still. The downside is that mergeout will need to read file directly from s3, rather than depot.

  • PanPan Employee

    And mergeout runs on primary subcluster instead of secondary subcluster, so it will always need to read from s3 if keep loading from secondary subcluster.

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.