Projections

Discussion List

• 
  ERROR: Too many ROS containers exist for the following projections

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

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

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

  Answered ✓ mferrall 8.6K 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 4.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 2.8K views 1 comment 0 points Most recent by mosheg April 2022General Discussion
• 
  Deleting unused projections

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

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

  Answered ✓ yamakawa 7K 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 5.2K 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 5.2K 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 3.2K views 1 comment 0 points Most recent by Vertica_Curtis April 2020General Discussion
• 
  User specified segmentation in Live Aggregate Projections?

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

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

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

  Answered Min_Yun_Chan 3.3K views 1 comment 0 points Most recent by ybei April 2020General Discussion
• 
  Checking and improving column compression and encoding

  Bryan_H 3.5K views 1 comment 1 point Most recent by Sharon_Cutter November 2019Tips from the Team
• 
  Projection Permission and Ownership

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

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