Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How do queries behave after a subcluster is removed?

What if a query is running on secondary subcluster and we remove the subcluster? Does the query restart on the primary subcluster?

Sizing and Configuring Vertica in Eon Mode for Different Use Cases
@skeswani @skamat

Answers

  • skeswaniskeswani Employee

    you can only run a query on a subcluster if you are connected to that subcluster. subclusters are an execution group and are isolated from other subclusters. removing a cluster will terminate all client connections to that subcluster and hence the queries running on those subclusters will fail.

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.