Do you find yourself running low on disk space on your Vertica database? You could delete older data, but that sacrifices your ability to perform historical queries. You could add new nodes to your cluster or add storage to your existing nodes. However, these options require additional expense.
The Vertica Storage Locations for HDFS feature introduced in Vertica Version 7.1 offers you a new solution: storing data on an Apache Hadoop cluster. You can use this feature to store data in a Hadoop Distributed File System (HDFS) while still being able to query it through Vertica.
Watch this video for an overview of the Vertica Storage Locations for HDFS feature and an example of how you can use it to free storage space on your Vertica cluster.
In Vertica version 8.0.0, we added integration for Apache Spark through our Vertica Connector for Apache Spark. This is a fast parallel connector that allows you to transfer data between Apache Spark and Vertica.
I have an entrepreneur friend who used to carry a butter knife around. He claimed this almighty tool was the only one he ever needed! While the butter knife does serve a wide range of purposes (especially with a stretch of the imagination), in practice it doesn't always yield optimal results. For example, as a...
Do you develop BI dashboards for Vertica? Or would you like to give it a try? To help you get started, the Vertica Partner Engineering team has created a set of QuickStart BI sample apps. You can download them for free from the
Interested in exploring the Vertica Analytic Database in the context of data movement and transformation? To get a feel for it, try our new ETL QuickStart sample apps. You'll find them on the Big Data Marketplace. Our Partner Engineering team develops QuickStart apps using tools from our technology partners. Currently we have ETL QuickStarts for...
You may not use more than 1TB (including Parquet and ORC External Tables) and 3 nodes.
You may not use software to provide services to third parties.
You may not distribute, resell, share or sublicense software to third parties.
You may not download and use patches, enhancements, bug fixes, or similar updates unless you have a license to the underlying software. Community Edition license does not give you a right to receive such updates.
You may not copy the Software or make it available on a public or external distributed network.
You may copy the Software for archival purposes or when it is an essential step in authorized use so long as You retain any product identification, trademark, copyright or other notices in the Software.
You may not modify, reverse engineer, disassemble, decrypt, decompile or make derivative works of the Software. If you have a right to do so under law, you must first inform Microfocus in writing about such modifications.
You may not disclose to any third-party performance information or analysis (including, without limitation, benchmarks and performance tests) from any source relating to the Software.
Support is not included. Additional information regarding the software may be available from the Vertica Community at https://forum.vertica.com. Vertica has no obligation to provide You with any bug fixes, upgrades, patches, new versions, new releases, or support.
You consent to the collection of anonymous analytics.
What are we collecting? We collect anonymized data including the date and timestamp, number of nodes, data size, storage size, version #, OS and other data. We’re collecting this information to learn how we can make the product better for you in the future.
How is this information stored and processed? We store and process all information on our secure servers. No third-party has access to any of this data.
What about my personal information? We do not track or store any personal data. All data collected is anonymized, including your IP address.