Projections

Discussion List

• 
  Checking and improving column compression and encoding

  Bryan_H 5.3K views 3 comments 1 point Most recent by bmurrell July 2025Tips from the Team
• 
  "Projection name - Projection base name" confusion

  Answered ✓ dimitri_p 1.5K views 3 comments 0 points Most recent by SruthiA March 2025General Discussion
• 
  ERROR: Too many ROS containers exist for the following projections

  Answered ✓ MrBudy01 47.9K views 12 comments 0 points Most recent by mosheg April 2023General Discussion
• 
  How to create a projection when creating a table?

  Answered ✓ jiahe1224 27.6K views 9 comments 0 points Most recent by marcothesane January 2023General Discussion
• 
  Optimizing DISTANCE using projections

  Answered zun 10.5K views 3 comments 0 points Most recent by Hibiki October 2022General Discussion
• 
  SALT in Segmentation Clause

  Answered ✓ mferrall 13.7K views 4 comments 0 points Most recent by VValdar August 2022General Discussion
• 
  How to expand k-safe / fault tolerance from 0 to 1, i have expand vertica db from 1 to 3 nodes ?

  Answered Bilal_raza 7.9K views 2 comments 0 points Most recent by mosheg July 2022General Discussion
• 
  How has global events in the last two years reshaped predictive analytics?

  Answered melroyr 4.4K views 1 comment 0 points Most recent by mosheg April 2022General Discussion
• 
  Deleting unused projections

  Answered ✓ yamakawa 7.6K views 2 comments 0 points Most recent by yamakawa April 2021General Discussion
• 
  Projections Hints

  Answered ✓ reli 20K views 6 comments 0 points Most recent by reli January 2021General Discussion
• 
  ​About super projection Optimization

  Answered ✓ yamakawa 11K views 3 comments 0 points Most recent by mosheg November 2020General Discussion
• 
  query plan is different between select from table and select from view

  sma 8K views 2 comments 1 point Most recent by sma July 2020General Discussion
• 
  Can some one explain me this Non privileged users are able to create projections when hints used?

  Answered ✓ sahil_kumar 7.9K views 2 comments -1 point Most recent by sahil_kumar June 2020General Discussion
• 
  Buddy projections after lowering K-Safety from 2 to 1

  Answered robbledobble 4.9K views 1 comment 0 points Most recent by Vertica_Curtis April 2020General Discussion
• 
  User specified segmentation in Live Aggregate Projections?

  Answered Min_Yun_Chan 8K views 2 comments 0 points Most recent by ChuckB April 2020General Discussion
• 
  Eon mode: projections created on ALL NODES or all shards?

  Answered DreaBrandford 4.9K views 1 comment 0 points Most recent by Pan April 2020General Discussion
• 
  How do aggregate projections affect the load performance?

  Answered Min_Yun_Chan 5K views 1 comment 0 points Most recent by marcothesane April 2020General Discussion
• 
  Example of scenarios to not define a projection?

  Answered Min_Yun_Chan 4.9K views 1 comment 0 points Most recent by ybei April 2020General Discussion
• 
  Projection Permission and Ownership

  abtsantosbenten 38.4K views 12 comments 0 points Most recent by abtsantosbenten July 2019General Discussion
• 
  Auto-Projection Column Sort Order

  Jim_Knicely 2.1K views 0 comments 0 points Most recent by Jim_Knicely July 2019Tips from the Team