We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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

davidvilladavidvilla ✭
in General Discussion

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

  • FiliNFiliN
    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;
  • davidvilladavidvilla ✭

    Thank you! I appreciate your help

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...