Options
Cluster Vertica : How does the distributed Query behave when all tables are unsegmented ?
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)
0
Comments
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.