Can you send a query to multiple subclusters?

GaryGGaryG Administrator
in General Discussion

Is there a way to send a single query to 2 subclusters for processing at a time?

Question asked at the 2020 Big Data Conference presentation Sizing and Configuring Vertica in Eon Mode for Different Use Cases given by @skeswani and @skamat .

Tagged:

Answers

  • skeswaniskeswani - Select Field - Employee

    The query is sent over a tcp connection to a single node, which is part of a single subcluster.
    so no, there is no way thru vertica to do this. however the client can connect independently to each subcluster and run the same query

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