Cluster Vertica : How does the distributed Query behave when all tables are unsegmented ?

TyTy
in General Discussion

Hello,

How the distributed query works on a cluster of Vertica when all my (small) tables are stored in mode replication (unsegmented) ?

For example, when i submit a SELECT FROM <table>, I think that only one node available on the cluster execute the SELECT.

 

Someone can confirm it ?

 

Many thanks for your help

 

Ty (Tai)

 

Comments

  • Curtis_1Curtis_1

    Yes.  If a projection is "UNSEGMENTED" (i.e., replicated) then whatever node you run the query on will answer the query exclusively. It won't involve any other node in the query execution.

     

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