The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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

Comments

  • 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 ?

    Regards,
    Raghav Agrawal

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.