Step 4: Load the Data

After you define the database schema, you load data into it. Vertica automatically creates a superprojection for each table into which data is loaded.

  1. Load data into the VMart database using the vmart_load_data.sql script.

    vmartdb=> \i vmart_load_data.sql

    vmart load data script (tutorial)

    Note: It could take several minutes to load the default five-million row fact table on a typical hardware cluster. You can check the load by examining the <DBMS_LOWERCASE>.log file, as described in Monitoring Log Files in the Administrator's Guide.

  2. Next, create a comprehensive design.