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.
is there any table to find the distribution of data across nodes based on segmentation???
+1
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;
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;
+1Thank you! I appreciate your help
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
