What does LOCAL RESEGMENT GROUPS mean?
When we do EXPLAIN <query>, sometimes it shows LOCAL RESEGMENT GROUPS. I'm just wondering what it means. Thanks.
0
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.
Comments
When you run a query that references more than one table, HP Vertica may need to do one or both of the following operations to join the tables together:
1) Sort the data
2) Resegment the data
Local resegment groups are formed by resegmenting the data during the query execution with a node so that more parallelism can be exploited by each core can work on each of the small segment of the data.
I hope this answers your question.
Regards
Rahul
Could you please explain for "LOCAL RESEGMENT GROUPS" and reason for joins in Plan with SQL involves one Table .
EXPLAIN SELECT COUNT(distinct customer_key) AS cntd_cust store_key, https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/AdministratorsGuide/EXPLAIN/PartiallySort...