Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
What is actually a Pinned Projection
What is Actually a Pinned Projection and how it releate only to Global Temp Table.
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
Hi
It has been clearly mentioned in the Vertica documentation that a projection for a temporary table that is only on the initiator node. It is neither segmented nor replicated on other nodes.
https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/Glossary/PinnedProjection.htm?Highlight=pinned
Thanks
Rahul