After being officially announced August 11 at the HP Big Data Conference, the Vertica “Excavator” release is finally here.
At the conference features such as data streaming with Kafka, machine log text search, open source flex table libraries were announced. The most exciting feature, Kafka Integration, is at the top of our list. Let’s highlight some of the other new features of this release.
- Official support for RHEL 7 and CentOS 7.
- Licensing: Flex licensing is now counted as 1/10th of regular Flex data towards Premium Edition license. Although implemented in 7.1.2, the license audit no longer includes the cost of a 1-byte delimiter.
- Client Tools: A Python Client is now offered to interface with the database as well as the passing of session parameters to Java or C++ UDx.
- Security: Vertica’s admintools no longer uses remote calls with SSH, and instead uses a remote python module. Privileges can now be inherited after grants at schema level. A
SYSMONITORrole now allows users limited access to certain system tables.
- Management: Vertica will now automatically detect and respond to unhealthy nodes by evicting them from the cluster. The catalog size has been reduced by consolidating statistics and metadata.
- Optimizer: Query hints and directed queries now allow for query plan caching and optimized plans (see our earlier post on this topic). The optimizer can now automatically direct queries to use a Live Aggregate/Top-K Projection.
- Backup/Reocvery: In addition to a recovery by table, individual objects can now be restored from a full backup.
The release is available for download through the Vertica Community Portal.