Vertica 7.1 “Dragline” Announced


Vertica just announced their newest release of Vertica, code named “Dragline.” This version introduces SQL-on-Hadoop, better access control, optimized back-ups, additional Flex Zone data format support, dynamic resource management and more.

The most significant feature of this release is the ability to run SQL queries on HDFS without the use of connectors. However, to perform faster in-depth analytics, the data would need to be moved into Vertica. As mentioned in the previous SQL-on-Hadoop post, MapR and Vertica can be run on the same hardware which allows for cost savings and better integration between the platforms.

In addition, this version introduces the following:

  • Ability to hide sensitive data as well as tighter security
  • File optimization to cut back-up and restore times decreasing the amount of bandwidth necessary to perform backups
  • Enhancements to Flex Zone supporting more data formats such as Parquet, Thrift, Avro, CEF, etc.
  • Ability to search through free-form text data, including machine logs and sentiment analysis
  • Better performing queries with aggregate functions such as SUM, MIN/MAX, and COUNT by using live aggregate projections
  • Better resource management through dynamic workload management which dynamically distributes resources to all requests

You can read the official press release or read the release data sheet. Official documentation and new feature notes are not yet available.

About the author / 

Norbert Krupa

Norbert is the founder of and a Solutions Engineer at Talend. He is an HP Accredited Solutions Expert for Vertica Big Data Solutions. He has written the Vertica Diagnostic Queries which aim to cover monitoring, diagnostics and performance tuning. The views, opinions, and thoughts expressed here do not represent those of the user's employer.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

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.
%d bloggers like this: