Skip to main content

What is actually a Pinned Projection

  • June 16, 2016
  • 1 reply
  • 8 views

chittaranjan_pr

What is Actually a Pinned Projection and how it releate only to Global Temp Table.

1 reply

Rahul_Choudhary
Forum|alt.badge.img
  • Participating Frequently
  • June 16, 2016

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