Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Are queries against default super projections distributed?
The documentation seems to indicate that those queries can still be distributed: "ALL NODES—Automatically replicates the unsegmented projection on each node. To perform distributed query execution, Vertica requires an unsegmented copy of each small table superprojection on each node." However, we've noticed that when the query planner uses a default super projection (UNSEGMENTED ALL NODES) for a query, the I/O and CPU load doesn't appear to get distributed across multiple nodes in the cluster. Is this expected? Can queries only be parallelized when they hit a projection which has been segmented by hash or range? Thanks, Emanuel Pordes