HPE Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. HPE Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption and deployment models. The core, unified architecture supports all leading BI and visualization tools and works with your current ETL tools to empower your analytics. Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.
With Vertica, there’s no need to maintain two different systems and thus two different storage locations for the same data to do both analytics and machine learning. Vertica offers speed at scale, even when concurrent users are performing analytics. Vertica supports both data scientists and SQL professionals with a single solution. Learn more in this webinar entitled “Building, training & operationalizing predictive analytic models with Vertica”.
To ensure you get the best value for your use case, there are now two editions of Vertica – premium and express. With Premium Edition, there are no limits to features, nodes or data size. The Vertica Express Edition includes a subset of Premium Edition features, but is offered at an even more affordable price. For example, it includes all the basic features such as Workload Management, but does not include more advanced features like Live Aggregate Projections. See the table on the right for details.
|User function creation (UDx)||✓||✓|
|Standard SQL (ANSI 99)||✓||✓|
|Workload analyzer, DB designer, Management console||✓||✓|
|Query Hadoop data (Ext table size is counted against license capacity)||✓||✓|
|Advanced SQL analytics (time series, SQL windowing, gap filling, more)*||✓|
|ROLAP SQL functions (Rollup, grouping sets, cube and pivot)||✓|
|Machine Learning (linear regression, k-means, more)||✓|
|Geospatial, R extensions||✓|
|Live aggregate projections||✓|
|Key Value interface||✓||Flattened table||✓|
Is your aging data warehouse system running out of gas? Download this report and learn how you can easily update your data warehouse to handle more data and complex analytics without spending millions in additional capacity expansion costs.