Handle Huge amount of Data Insert into Vertica

• The Vertica Database Forums • View topic - COPY command has ETL capabilities
• Teaching the elephant new tricks
• bulk load tip with vertica example, enhancement suggestion to TextFileOutput
• The Vertica Database Forums • View topic - WOS and ROS
• https://database.cs.brown.edu/svn/hstore/tags/release-2011-04/tests/extensions/org/voltdb/VerticaLoaderTest.java
• Quick and dirty tester for different Vertica bulk load method

How to use VerticaCopyStream

VerticaCopyStream stream = new VerticaCopyStream((VerticaConnection)conn, stmt);

stream.start();

stream.addStream(pipedInputStream);

stream.execute();

stream.finish();

conn.commit();