Welcome to the Vertica Forum

Discussion List

• 
  How to create a projection when creating a table?

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

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

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

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

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

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

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

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

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

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

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

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

  Jim_Knicely 739 views 0 comments 0 points Started by Jim_Knicely July 2019 Tips from the Team