Unsegmented Clause
Specifies to distribute identical copies of table or projection data on all nodes across the cluster. Use this clause to facilitate distributed query execution on tables and projections that are too small to benefit from segmentation.
Vertica uses the same name to identify all instances of an unsegmented projection. For more information about projection name conventions, see Projection Naming.
Syntax
UNSEGMENTED ALL NODES
Example
This example creates an unsegmented projection for table store.store_dimension
:
=> CREATE PROJECTION store.store_dimension_proj (storekey, name, city, state) AS SELECT store_key, store_name, store_city, store_state FROM store.store_dimension UNSEGMENTED ALL NODES; CREATE PROJECTION => SELECT anchor_table_name anchor_table, projection_name, node_name FROM PROJECTIONS WHERE projection_basename='store_dimension_proj'; anchor_table | projection_name | node_name -----------------+----------------------+------------------ store_dimension | store_dimension_proj | v_vmart_node0001 store_dimension | store_dimension_proj | v_vmart_node0002 store_dimension | store_dimension_proj | v_vmart_node0003 (3 rows)