Expanding the power of Vertica Library for AWS with Filter Functions

After publishing the “Loading data from AWS S3 bucket to Vertica made easy” post I had people asking me about the possibility of using the S3 function to load data in different formats. The most frequently asked question was about loading GZipped files from the S3 bucket. Vertica COPY command expects an uncompressed CSV input Read More …

Exporting Vast Amounts of Data Using Parallel Export for HPE Vertica

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 …