Month: August 2016

Exporting Vast Amounts of Data Using Parallel Export for HPE Vertica

Posted on1 Comment

Sometimes you can find yourself in a position in which you need to export data out of Vertica. It is not a problem for small data sets, but could be challenging if you have millions of records. If you try to use vsql for this purpose you will be doing the export through a single Read More …

Using Database Designer to Optimize Specific Class of Queries in HP Vertica

Posted onLeave a comment

A lot of people who are new to Vertica ask if you can create an index on a table in a Vertica database. The answer they get is NO. Vertica does not have a CREATE INDEX statement and does not have the concept of an index. Let’s see if we can come up with something Read More …