Bulk Loading Tables

The Yellowbrick bulk loader (ybload) is a Java-based bulk data loader that you invoke from a client system (not from a node within a Yellowbrick cluster). You can load very large data files from remote systems by running this utility. Yellowbrick recommends using the bulk loader to load all of your database tables.

The loader distributes the data in parallel directly to the worker nodes, based on the distribution key in the CREATE TABLE statement. The utility loads a single destination table that you specify, appending the loaded rows to any existing rows in the table. (The loader does not detect duplicates or update existing rows.)

Yellowbrick recommends that you upgrade to the latest version of the ybtools clients when you upgrade the appliance so that your client and server versions correspond. The client tools are backward-compatible but not always forward-compatible.