is there any table to find the distribution of data across nodes based on segmentation???

I have created a projection based on particular segmentation. I want to see how the segmenation functioned to distribute the data across nodes. please help.

Comments

  • select
    s.node_name,s.schema_name,s.projection_name,s.storage_type,s.total_row_count
    from v_monitor.storage_containers s where s.projection_name=:your_projection_name;
  • Thank you! I appreciate your help

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.