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
COUNTby using live aggregate projections
- Better resource management through dynamic workload management which dynamically distributes resources to all requests