The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Data Distribution in nodes

We are having 6 nodes cluster, most of the projections are segmented by hash() all nodes ksafe 1, but 90% table data distribution is happening in 2 nodes, it not evenly distributing in 6 nodes


  • qinchaofengqinchaofeng Vertica Customer

    Please ensure your segmented column is well-distributed,if not ,you can use two distributed columns

  • Hi,

    We used to face same problem. Can you share me ddl for any 1 table which is incorrectly segmented ?

    Raghav Agrawal

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file