• Conferences

    Early Bird Rate Extended


    The early bird rate for the Vertica Big Data Conference 2014 has been extended to May 16. The rate is $295 for the core conference with optional pre-conference hackathon. In addition, Vertica is still accepting abstracts for papers to be potentially presented at the conference. Check out the official site for details.

  • Best Practices

    Enforcing Uniqueness of Data on Load


    Vertica does not enforce uniqueness of primary key or unique constraints on load due to the potential overhead associated with the operation. There are ways to enforce uniqueness on load such as using MERGE, ANALYZE_CONSTRAINTS() or staging the data in a temporary table. This post will discuss these methods and potential restrictions around them.

  • Tips & Tricks

    Ignore Projections During Optimization


    I just learned about an undocumented function which allows you to tell the optimizer to ignore certain projections. Ignoring projections can be useful for testing or when optimizing queries. This post will show how to use the set_optimizer_directives() function to accomplish this.

  • News

    Vertica 7 Training Webinar


    HP held a 3-part webinar on an overview of Vertica 7 back in January. This webinar discussed installation improvements, fault groups, load improvements, SQL Server improvements, and query optimizer improvements.

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.


This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.