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.
-
Load data into the VMart database using the
vmart_load_data.sql
script.vmartdb=>
\i vmart_load_data.sql
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. - Next, create a comprehensive design.