Loading Data Through JDBC

You can use any of the following methods to load data via the JDBC interface:

• Executing a SQL INSERT statement to insert a single row directly.
• Batch loading data using a prepared statement.
• Bulk loading data from files or streams using COPY.

When loading data into Vertica, you need to decide whether to write data to the Write Optimized Store (WOS) or the Read Optimized Store (ROS). By default, most data loading methods insert data into the WOS until it fills up, then insert any additional data directly into ROS containers (called AUTO mode). This is the best method to use when frequently loading small amounts of data (often referred to as trickle-loading). When performing less frequent large data loads (any loads over 100MB of data at once), you should change this behavior to insert data directly into the ROS.

The following sections explain in detail how you load data using JDBC.